Exam 14: Managing Database and Sql Performance

The purpose of an I/O operation is to move data to and from different computer components or devices.

____________________ are special instructions for the optimizer that are embedded inside the SQL command text.

The ____ table space is used for transaction-recovery purposes.

Knowing the sparsity of a column helps you decide whether the use of ____ is appropriate.

The majority of primary memory resources will be allocated to the ____ cache.

The ____ table space is used as a temporary storage area for merge, sort, or set aggregate operations.

To generate database object statistics manually, you could use the following syntax: ____.

To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.

____ refers to the number of different values a column could possibly have.

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.

The SQL cache stores the end-user written SQL.

DBMS query processing has ____________________ phases.

The ____ table space is used to store end-user data.

List and describe some typical DBMS processes.

When setting optimizer hints, ____ forces the optimizer to use the P_QOH_NDX index to process this query.

Good database performance is easy to evaluate.

Indexes do not facilitate join operations.

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) ____________________ plan.

A data file can only contain rows from one single table.