Exam 9: Constraints, indexes, and Other Specialized Objects

The ON DELETE ____ setting tells Oracle 10g that when a parent row is deleted,all the related child rows are also deleted.

A(n)____ constraint appears after the full list of columns in the CREATE TABLE command and is usually used to define constraints to multiple columns.

____________________ constraints are constraints defined at the database level on either a column or a table.

The ____ constraint enforces a predefined list of values for a column.

The NOT NULL constraint must always be defined out of line.

A(n)____ integrity constraint is the column or set of columns that define a unique identifying value for every row in the table.

To add a ____ constraint successfully,all rows in the table must contain values for the column.

The CHECK constraint can only use values within the current ____________________.

If successful,the ALTER INDEX ...REBUILD command automatically corrects an index that has been marked ____ because a change was made to the structure of the underlying table or partition.

The ____________________ view (and its corresponding DBA and USER views)contains the definition of a view.

A ____ index cannot contain any DESC columns.

A UNIQUE constraint is often used in place of a PRIMARY KEY.

Sequence values can be accessed using the ____ and NEXTVAL pseudocolumns.

A(n)____________________ index is an index on a partitioned table,in which the index is partitioned in the same way and on the same columns as the table.

You should use the NOT NULL constraint for columns holding essential information.

A(n)____________________ value is an empty column within a table row and usually means that the column value for that row is unknown or not applicable.

The ____ data dictionary view contains the definition of a constraint.

A(n)____ constraint appears immediately next to the column to which it applies.

The UNIQUE key constraint and the ____ constraint are very similar.

What is a bitmap index?