Q5
The primary key is selected from the:
A.
composite keys.
B.
determinants.
C.
candidate keys.
AnswerD.
foreign keys.
Answer: Option C
Solution
Answer: Option C
Solution:
Option1: Composite keys are keys that consist of multiple attributes to uniquely identify a record in a table. The primary key is not selected from composite keys because it is a single attribute or a combination of attributes that uniquely identifies each record in a table.
Option2: Determinants are attributes that determine other attributes in a table. The primary key is not selected from determinants because it is the key that uniquely identifies each record in a table, not an attribute that determines other attributes.
Option3: Candidate keys are keys that could potentially be selected as the primary key for a table. The primary key is selected from candidate keys because it is the key that is chosen to uniquely identify each record in a table.
Option4: Foreign keys are keys that establish a relationship between two tables. The primary key is not selected from foreign keys because it is a key that uniquely identifies records within a single table, not a key used to establish relationships between tables.
Conclusion: The primary key is selected from the candidate keys. Candidate keys are keys that could potentially be chosen as the primary key for a table, and the primary key is the key that is ultimately selected to uniquely identify each record in a table.