Question

A table has two candidate keys, one of which is chosen as the primary key. How many alternate keys does this table have?

Options

• 0

• 1

• 2

• 3

Answer 1

1

Explanation:

A Candidate Key is any attribute that can uniquely identify a record in a table. When a table has multiple candidate keys, only one is selected to be the Primary Key. All remaining candidate keys are then referred to as Alternate Keys. In this problem, since one of the two candidate keys is chosen as the primary key, exactly one remains to be the alternate key.