The candidate key chosen by the designer to identify tuples is the:
AProvisional key
BProgressive key
CPrimary key
DPeripheral key
Answer & Solution
Correct answer: C. Primary key
1. Several candidate keys may exist in one relation.
2. Only one of them is actually adopted.
3. The candidate key chosen by the designer to uniquely identify tuples is the primary key.
4. So the answer is the primary key.
_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.