A candidate key that is not selected as the primary key is called ________.

Options

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

Correct Answer (Detailed Explanation is Below)

B. Alternate key

Detailed Explanation

  • Alternate key: A candidate key that is not selected as the primary key.
  • A table may have multiple candidate keys but only one primary key.
  • The remaining candidate keys are called alternate keys.