Bright Tutorials Bright Tutorials
CBSE Class 11 Informatics Practices Question 72 of 87

Structured Query Language (SQL) — Question 33

Back to all questions
33
Question

Question 27(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.