SQL Server Notification Services Question:
Download Questions 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.

Download SQL Notification Services Interview Questions And Answers PDF

Previous QuestionNext Question
Define Primary and Unique key?Define Distributed Query and Linked Server?