Exam 9: Constraints, indexes, and Other Specialized Objects

Application constraints cannot be fine-tuned for each application.

____ is a pseudocolumn that represents the current date and time.

A(n)____________________ is an overlay onto one or more tables.

The ____ data dictionary view lists the columns associated with each constraint.

The ____ index is used on partitioned tables where the index is created on all partitions for the entire table,as a single index.

In addition to providing faster access to data,certain indexes also have a second purpose: enforcing a PRIMARY KEY constraint or ____ constraint.

What is a reverse key index?

____________________ constraints are simple to create and maintain because they are centralized.