Exam 9: Constraints, indexes, and Other Specialized Objects

A bitmap index can be a UNIQUE index.

____ integrity is the integrity,or soundness of data,maintained between two values,which reference each other.

Constraints are enabled by default when you create them.

What is the role of the VALIDATE|NOVALIDATE constraint state?

Although CHECK constraints can check multiple conditions,it is usually better to use multiple CHECK constraints instead of one complicated constraint.

A query ____________________ is the ability of Oracle 10g to modify the query you execute,changing it into an equivalent but more efficient statement before actually running the query.

Columns with null values are ignored by the UNIQUE constraint.

When no name is specified in a constraint,you should omit the ____________________ keyword and the constraint name.

A(n)____________________ index is an index with one or more columns indexed that are actually expressions or functions instead of columns.

A(n)____________________ key establishes a relationship between two tables,in which one is the parent and the other is the child.

A ____ view is a view that can be used to insert a new row into the underlying table,as long as the row would be returned by a query,or the row exists for the view.

A FOREIGN KEY constraint that is defined out of line is not allowed to have a name.

Integrity constraints are always enforced,no matter what application or tool is used to modify a table's data.

An index created to support a ____ constraint does not allow any null values in any of the indexed columns,because there is an automatic NOT NULL constraint added to a primary key column.

You ____________________ an index to consolidate fragmented storage space in the leaf blocks.

CHECK constraints cannot use pseudocolumns,such as ____ and USER.

The column or columns of a PRIMARY KEY may contain null values.

An index does not have its own storage specification,so it has to be in the same tablespace as the associated table.

Constraints that apply to multiple columns,such as a constraint for a compound foreign key,are called ____________________ constraints and are placed immediately after the list of columns in the CREATE TABLE command.

A(n)____________________ can provide an alias to any object,in any schema in a database,assuming that the user has privileges to view the underlying objects.