Computer Science
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.
DDL & DML
1 Like
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.
Answered By
1 Like
Related Questions
Conditional updates in table data are possible through UPDATE command.
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.
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.
Assertion. There are different commands for creating and changing table design.
Reason. The CREATE TABLE command creates the tables while ALTER TABLE command changes the design of an existing table.