Computer Science
Assertion. The PRIMARY KEY and UNIQUE constraints are the same.
Reason. The columns with PRIMARY KEY or UNIQUE constraints have unique values for each row.
DDL & DML
1 Like
Answer
(d)
Assertion is false but Reason is true.
Explanation
UNIQUE and PRIMARY KEY constraints are not the same and there are differences between them. Though both ensure unique values for each row in a column, but UNIQUE allows NULL values whereas PRIMARY KEY does not. Also, 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
3 Likes
Related Questions
DELETE from <table> command is same as DROP TABLE command.
Conditional updates in table data are possible through UPDATE command.
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.
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.