Which of the following is true?
i. A primary key by default checks for not null and uniqueness conditions.
ii. A primary key by default checks only for uniqueness.
iii. A primary key can be a composite key.
iv. A primary key can never be a composite key.
-
i. and iv. are true
-
i. and iii. are true
-
ii. and iv. are true
-
ii. and iii. are true
B
Correct answer
Explanation
This answer is correct. A primary key by default checks for both not null and the uniqueness conditions. Primary key will verify whether the value inside the column is null or not, and also unique from the other values or not. A primary key can also be a composite key. It can have one or more columns as a primary key.