Post Views: 1,794 Here is some important SQL Interview Questions and Answers, these SQL Interview Questions and Answers may be help in your interview round. SQL Interview Questions and Answers What are difference between DELETE & TRUNCATE commands? Delete command removes the rows from a table based on the condition that we can write WHERE clause […]
Post Views: 1,134 char[(n)] – It is fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character. nvarchar(n) – Variable-length Unicode character data of n characters. n must be a value from 1 through […]
Post Views: 922 What is Weak Entity set? An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.
Post Views: 841 What are the difference between a primary key and a unique key? Primary key and a Unique key enforce unique value of the column on which they are defined. Main difference between them is that, primary key doesn’t allow any NULLs, but unique key allows one NULL only, and another difference is by default primary key […]
Post Views: 883 What is difference between DELETE & TRUNCATE commands? This is most common interview question related to SQL and Database, every programmer must know differnce between Delete and Truncate. Delete command removes the rows from a table based on the condition that we can write WHERE clause in delete command. Truncate command will actually remove […]
Post Views: 1,242 Playing with Sql String | Splitting String in SQL How to Split value of column in Sql Query? Requirement : Sometime we need to filter/ split the values of column, for example, we need to take only first name from the column since there is value in the column is firstname.lastname and we […]