DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

What is difference between UNIQUE constraint and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

35. What is difference between UNIQUE constraint and PRIMARY KEY constraint?

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can’t contain Nulls. 47.What is Index Cluster? - A Cluster with an index on the Cluster Key 48.When does a Transaction end? - When it is committed or Rollbacked.

(Continued on next question...)

Other Job Interview Questions