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

Table Creation and Data Manipulation Commands — Question 3

Back to all questions
3
Question

Question 3

Assertion. There is no restriction on the number of columns that can have PRIMARY KEY constraint or UNIQUE constraints.

Reason. There can be multiple columns with UNIQUE constraint but PRIMARY KEY constraint can be defined only once for one or more columns.

Answer

(d)

Assertion is false but Reason is true.

Explanation
There can exist multiple columns with UNIQUE constraints in a table, but there can exist only one column or one combination with PRIMARY KEY constraint.