What is the difference between a primary key and a unique key?

Question

Accepted Answer

Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column.

Primary key cannot have null values, while unique key can have one null value.
A table can have only one primary key, but multiple unique keys.
Primary key is automatically indexed, while unique key may or may not be indexed.
Example: Primary key - employee ID, Unique key - email address

Accepted Answer

Google pay customer care helpline number...7070084343...9973097330

Accepted Answer

Google pay customer care helpline number...7070084343...9973097330

Accepted Answer

Google pay customer care helpline number...7070084343...9973097330

Cognizant Associate Software Engineer interview questions & answers