Question

The criteria for selecting a primary key for a table: A. It must uniquely identify the row.
B. It cannot have NULL value.
C. It can have NULL value.
D. It can have duplicate values.
E. It never uniquely identifies the row.
%Option

• A. A and B only
• B. C and D only
• C. B and E only
• D. A and E only

Hint:

A primary key is unique for each record in the table and cannot have NULL values. It helps in identifying rows and establishing relationships between tables.

Answer 1

The Correct Option is A

A primary key must uniquely identify each row in a table and cannot have NULL values. Therefore, the correct criteria are: - It must uniquely identify the row (A) - It cannot have NULL values (B) Thus, the correct answer is A and B only.