Keys
August 9, 2024GATE 2008
August 9, 2024Keys
| Question 4 |
A ___ is the combination of one or more column values in a table that make a row of data unique within the table
| Foreign key | |
| Natural key | |
| Candidate Key | |
| Primary Key |
Question 4 Explanation:
CANDIDATE KEY is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. The Primary key should be selected from the candidate keys. Every table must have at least a single candidate key. A table can have multiple candidate keys but only a single primary key.
Correct Answer: C
Question 4 Explanation:
CANDIDATE KEY is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. The Primary key should be selected from the candidate keys. Every table must have at least a single candidate key. A table can have multiple candidate keys but only a single primary key.