Class - 12 CBSE Computer Science — Assertion Reason Type Questions
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.
DDL & DML
1 Like
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.
Answered By
2 Likes