SQL Database Concepts Interview Question:

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

Submitted by: Administrator

- 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.
Submitted by: Administrator