Which key uniquely identifies each record in a relational database table?

Options

  • A. Foreign Key
  • B. Primary Key
  • C. Candidate Key
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Primary Key

Detailed Explanation

  • A Primary Key uniquely identifies every record in a table.
  • It cannot contain NULL values and must contain unique values.
  • A table can have only one primary key constraint, which may consist of multiple columns.