Question

If a table which has one Primary key and two alternate keys. How many Candidate keys will this table have? 

Options

• 1

• 2

• 3

• 4

Answer 1

3

Explanation:

1. Candidate Keys are the smallest set of attributes that can uniquely identify a row in a table.
2. In your case: 
   1. Primary Key: A primary key is always a candidate key.
   2. Alternate Keys: These candidate keys are not picked as the primary key.
3. Thus, the table will have 3 candidate keys: 1 Primary Key, 2 Alternate Keys.