Exam 9: Constraints, indexes, and Other Specialized Objects

When viewing constraints from ALL_CONSTRAINTS,foreign key constraints are indicated with the letter ____.

The ____ index is used for application- or cartridge-specific indexes.

A(n)____ index is an index that is partitioned when either the table is not partitioned or the table is partitioned in a different way than the index.

When executing a package or a procedure,you must either wrap the command in a PL / SQL block by using the BEGIN and END;clauses on either side of the command,or type ____ and the command all on a single line.

A(n)____________________ key is often a system-generated number,guaranteeing uniqueness and stability.

Constraints that apply to a single column are called ____________________ constraints and appear inline with the column.

Triggers are at the database level and provide more flexibility in designing complex constraints than integrity constraints,while keeping the constraint within the database.

An index can have from one to ____ columns (only 30 columns if it is a bitmap index).

Unless you specifically instruct Oracle 10g to create a bitmap index,it always creates a ____ index.

Placing the ____ constraint on a column indicates that all rows in the table must contain a value in the column.

You can create a ____ index on a nonpartitioned table.

An index containing multiple columns is called a(n)____________________ index.

Modifications to the database are affected by application constraints.

A ____ is a program that runs when a certain event occurs.

When you join tables together,you are nearly always using a column or set of columns in one table that corresponds to a column,or set of columns in another table.

One of the rules of ____________________ is that every table should have a key that contains a unique value for every row.

____ checking performs faster than other methods of constraint enforcement,because the optimizer has been programmed to handle them efficiently.

The ____ index is by default a BTree but can also be a hash-clustered index.

The ____________________ index is an index structure in which data is divided and subdivided based on the index key values to minimize the look-up time when searching for a key value.

The ____ constraint is similar to the PRIMARY KEY constraint because both enforce unique values;the difference is that it allows null values in the column or columns that are named in the constraint.