Exam 9: Constraints, indexes, and Other Specialized Objects

____________________ are used to contain automated counter values,most commonly used to retain counter values for integer-valued primary keys.

You cannot change the state of a NOT NULL constraint.

A table can have multiple PRIMARY KEY constraints.

When you drop a ____ constraint,the associated index is also dropped.

____________________ indexes include table rows that have null values in all the indexed columns.

When viewing constraints from ALL_CONSTRAINTS,NOT NULL constraints are listed as ____ constraints,and have system-assigned names.

Frequently,NOT NULL and CHECK constraints are not named.

The reverse key index is a type of ____ index used to improve efficiency of Oracle Real Application Clusters.

Most tables have a primary key to comply with the standards of normalization of tables.

The ____ constraint helps validate the value within a column or a set of columns within one row.

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

____________________ constraints enforce only those changes that are made within the application.

PRIMARY KEY column(s)is / are usually placed ____ the table.

ON DELETE ____ instructs Oracle 10g to set the value of the foreign key column in the related child rows to null instead of deleting the rows.

By default,the initial value of a sequence when it is first created is 0.

It is advisable to specifically name at least all PRIMARY KEY and ____ constraints.

Creating a primary key in an Oracle 10g database automatically creates an internal unique ____________________.

It is possible to create an index owned by one user on a table owned by another user,provided that the creating user has either the CREATE ANY INDEX privilege or the INDEX privilege on the target table,or the user has been granted specific privileges for creating an index on that table.

Any constraint other than ____ can be dropped using the ALTER TABLE DROP CONSTRAINT command.

A(n)____________________ is a database structure that is associated with a table or a cluster and speeds up data retrieval when the table or cluster is used in a query.