SQL Server Notification Services Question:
Download Job Interview Questions and Answers PDF
Explain the difference between a primary key and a unique key?
Answer:
► Both are defined to ensure unique row.
► Primary key creates a clustered index on the column by default.
► Unique creates a non-clustered index by default.
► Primary key doesn't allow NULLs, but unique key allows one NULL only.
► Primary key creates a clustered index on the column by default.
► Unique creates a non-clustered index by default.
► Primary key doesn't allow NULLs, but unique key allows one NULL only.
Download SQL Notification Services Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Define Primary and Unique key? | Define Distributed Query and Linked Server? |