Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 2 of 79

Table Creation and Data Manipulation Commands — Question 2

Back to all questions
2
Question

Question 2

Assertion. The treatment of NULL values is different with PRIMARY KEY and UNIQUE constraints.

Reason. The column(s) with PRIMARY KEY do not allow the NULL value even in a single row but UNIQUE constraint allows NULL for one of the rows.

Answer

(a)

Both Assertion and Reason are true and Reason is the correct explanation of Assertion.

Explanation
The treatment of NULL values is different with PRIMARY KEY and UNIQUE constraints. The UNIQUE constraint allows NULL values for one of the rows, while the PRIMARY KEY does not allow the NULL value in any row.