Question

A set of one or more attributes that can uniquely identify a record in a database is called

• A. Super key
• B. Candidate key
• C. Alternate key
• D. Primary key

Hint:

A Candidate key is a minimal set of attributes that uniquely identifies a record in a table. It can be one or more columns.

Answer 1

The Correct Option is B

In database management, a Candidate key is a set of one or more attributes (columns) that can uniquely identify a record in a table. It is called a candidate because multiple sets of attributes can be considered as potential keys.

Step 1: Definition of Candidate key
A Candidate key is a minimal superkey, meaning that no attribute can be removed from the key without losing its ability to uniquely identify records.

Step 2: Conclusion
Thus, the correct answer is Candidate key.

Final Answer: Candidate key.