Question

The attributes which have all the properties of primary key

Options

• Foreign key

• Alternate key

• Candidate key

• Both (1) and (3)

Answer 1

Candidate key

Explanation - 

Both the candidate key and the primary key serve the same function, which is to individually identify the tuples. The distinction between the two is that while a table may have one or more candidate keys, it may only have one primary key.