Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 88 of 103

Review of Database Concepts & SQL — Question 37

Back to all questions
37
Question

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