Post Views: 1,795 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 […]
SQL Interview Questions and Answers
Post Views: 1,135 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: 924 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: 842 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: 885 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 […]