Which of the following statements about creating constraints is incorrect?
A) If a constraint applies to more than one column,the constraint must be created at the table level.
B) Using the column level approach,the definition of the constraint is included as part of the column definition.
C) When you create constraints at the column level,the constraint being created applies to the column specified.
D) The NOT NULL constraint can be created at either the column level or the table level.

Question

​Which of the following statements about creating constraints is incorrect?​
A) ​If a constraint applies to more than one column,the constraint must be created at the table level.
B) ​Using the column level approach,the definition of the constraint is included as part of the column definition.
C) ​When you create constraints at the column level,the constraint being created applies to the column specified.
D) ​The NOT NULL constraint can be created at either the column level or the table level.

Quizplus · Accepted Answer

The NOT NULL constraint is an exception in that it can only be created at the column level, not at the table level. This is because it directly relates to the individual column's requirement to not accept NULL values.

​Which of the Following Statements About Creating Constraints Is Incorrect?​

Which of the Following Statements About Creating Constraints Is Incorrect?