Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 75 of 91

Relational Database and SQL — Question 36

Back to all questions
36
Question

Question 29(a)

What is the difference between Candidate key and Alternate key?

Answer
Alternate KeyCandidate Key
A candidate key refers to all the attributes in a relation that are candidates or are capable of becoming a primary key.Any attribute which is capable of becoming a primary key but is not a primary key is called an alternate key.