What is a candidate key in a relational database?

Options

  • A. A key that contains duplicate values
  • B. A minimal set of attributes that uniquely identifies a record
  • C. A key used only for sorting records
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. A minimal set of attributes that uniquely identifies a record

Detailed Explanation

Explanation: A Candidate Key is a minimal super key. It uniquely identifies a tuple, and no attribute can be removed without losing uniqueness.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 1

Feature Posts