Exam 4: Constraints

Which of the following are used to enforce business rules?

When used with a FOREIGN KEY, the keyword REFERENCES refers to what?

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.

Which clause will allow you to disable a constraint?

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?

A foreign key constraint can only be created at the column level.

A(n) ____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.

Constraints are always enforced at the ____ level.

A FOREIGN KEY constraint can only reference a column in another table that has been assigned a(n) ____ constraint.

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.

Which of the following is not a constraint type in Oracle11g?

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.

The ____ constraint prevents the user from adding a NULL value in the specified column.

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table?

Only one ____ constraint can exist for each table.

The ____ constraint requires that a specific condition be met before a record can be added to a table.

A constraint is created at the ____________________ level if it is included as part of the column definition.

If a data value violates a(n) $\underline { \text { constraint } }$ , the entire row is prevented from being added to the table. _________________________