Exam 9: Constraints, indexes, and Other Specialized Objects

A data dictionary view named ____ lists indexed column names and statistics either owned by the user or accessible to the user.

You can use expressions in function-based indexes.

Oracle 10g supports ____ types of integrity constraints.

You can use ALTER INDEX to change the column order of an existing index.

An index does not store an entry for a row when all the indexed columns are null except if the index is a bitmap index.

The indexed columns in a ____ index should have low cardinality.

The PRIMARY KEY constraint is not important for the integrity of the table.

A constraint ____ is the attribute that tells Oracle 10g how to use the constraint when data is added to the table.

How is data divided in a BTree?

A bitmap index stores ROWID values and key values.

You can use the ____ constraint to compare one column against another column.

CHECK constraints cannot contain queries or any references to other tables.

A table can have more than one UNIQUE constraint.

The ____ index is used to store pre-computed expression values based on table columns.

Naming constraints is mandatory.

The ____ command provides a way to change a named constraint or all constraints to a deferred state during your session.

The syntax for adding a CHECK constraint with CREATE TABLE and ALTER TABLE is quite different.

If you omit the ____ parameter,you cannot delete a row from the parent table,if it has related children in other tables.

What are the advantages of the integrity constraint method of enforcing constraints over the other methods?

There are only ____ constraint-related data dictionary views.