Which key is selected from the candidate keys to uniquely identify records in a table?

Options

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

Correct Answer (Detailed Explanation is Below)

A. Primary key

Detailed Explanation

  • Primary key: The candidate key selected to uniquely identify records in a table.
  • A primary key must contain unique values and cannot contain NULL values.
  • A table can have only one primary key constraint, which may contain multiple columns.