The Relational Model and Normalization - Technical MCQs

Q1:

The primary key is selected from the:

A composite keys.

B determinants.

C candidate keys.

D foreign keys.

ANS:C - candidate keys.

A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table.

Each Candidate Key can qualify as Primary Key. Primary Key " A Primary Key is a column or a combination of columns that uniquely identify a record.