The primary key of a table is chosen among:
A) All attributes
B) All superkeys
C) All combinations of all attributes
D) All candidate keys

Question

Quizplus · Accepted Answer

The primary key should be chosen from the set of candidate keys, which are minimal superkeys that uniquely identify all tuples in a table. Choosing a non-candidate key may result in data redundancy, inconsistent data, and other issues. Therefore, option D is the best choice as it specifies that the primary key should be chosen among all candidate keys.

The Primary Key of a Table Is Chosen Among