What Is The Difference Between Unique Key And Primary Key? | SQL Interview Question

• Unique Key can have nulls but primary keys cannot have null values.
• We can create multiple unique keys on a table but we can have only one primary key on a table.
• Unique key creates a non-clustered index by default, primary key creates a clustered index by default.