SQL Database Concepts Question:
Download Questions PDF

Can you please differentiate between a primary key and a unique key?

Answer:

- By default, clustered index on the column are created by the primary key whereas nonclustered index are created by unique key.
- Primary key doesn't allow NULLs, but unique key allows one NULL.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what is the function of SQL Server Agent Windows service?Tell me what are the advantages of using Stored Procedures?