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.