Question

what is primary and candidate key

Answer 1

Answer:

Primary Key is a unique and non-null key which identify a record uniquely in table. A table can have only one primary key. Candidate key is also a unique key to identify a record uniquely in a table but a table can have multiple candidate keys.

Answer 2

I hope it will be helpful for you