What is an alternate key in a relational database?

Options

  • A. A candidate key selected as the primary key
  • B. A candidate key not selected as the primary key
  • C. A key containing duplicate values
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. A candidate key not selected as the primary key

Detailed Explanation

Explanation: An Alternate Key is a candidate key that is not selected as the primary key. It can still uniquely identify records.