Exam 4: Constraints

A(n) $\underline { \text { FOREIGN KEY } }$ constraint can only reference a column in the parent table that has been designated as the primary key for that table. _________________________

Which of the following statements about creating constraints is incorrect?

The NOT NULL constraint can only be created at the ____ level.

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.

With the exception of the NOT NULL constraint, constraints can be added to a table using the ADD clause of the ALTER TABLE command.

A UNIQUE constraint is the same as a PRIMARY KEY constraint, except that it will accept NULL values.

Structure of the PROMOTION table -Based on the structure of the PROMOTION table, which of the following commands will ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?

When a constraint is created at the ____ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.

In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a NOT NULL constraint.

When dropping a(n) $\underline {\text { PRIMARY KEY } }$ constraint, the name of the column does not need to be included in the ALTER TABLE command. _________________________

Any constraint can be created at the table or the column level.

A constraint for a composite primary key must be created at the table level.

Unless a PRIMARY KEY or a(n) ____________________ constraint is being dropped, the actual name assigned to the constraint must be included in the ALTER TABLE command.

Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

If a constraint applies to more than one column, the constraint must be created at the ____ level.

A $\underline { \text { Datatype } }$ is a rule used to ensure the accuracy of data stored in a database. _________________________

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint, named ORDERITEMS_PK, exists for the ORDER# and ITEM# columns of the ORDERITEMS table, which of the following commands will disable the constraint?

Constraints are used to ensure the accuracy and integrity of the data contained in the database.

Each column can only be included in one constraint.

When dropping a constraint, the user is always required to specify the name of the constraint being dropped.