CBSE · 083Class XII · 2023Section B2 marks
Question 22
30 March 2023 · Computer Science (083)
Explain the concept of "Alternate Key" in a Relational Database Management System with an appropriate example.
Answer
An Alternate Key is any Candidate Key that is not chosen to be the Primary Key. For example, in a Student table with Candidate Keys {AdmNo, RollNo}, if AdmNo is the Primary Key, then RollNo is the Alternate Key.
Explanation
It's a candidate key not selected as primary.