Candidate keys not chosen as the primary key are called:
AAdjacent keys
BAncillary keys
CAssistant keys
DAlternate keys
Answer & Solution
Correct answer: D. Alternate keys
1. Only one candidate key becomes the primary key.
2. The rest are not discarded, they are named.
3. The remaining attributes in the list of candidate keys are called alternate keys.
4. So the answer is alternate keys.
_Source: syllabus Computer Science, Ch 8 'Database Concepts'_
Keep practising Database Concepts
Browse all Database Concepts questions for IGNOU MCA, or explore more Computer Science topics.