Exam 11: Database Performance Tuning and Query Optimization

Summarize the steps required to formulate a query.

In standard SQL, the optimizer hintALL_ROWS is generally used for _____ mode processes.

The _____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.

Database _____ activities can be divided into those taking place either on the client side or on the server side.

Working with data in the data cache is many times faster than working with data in the data files.

All transaction management commands are processed during the parsing and execution phases of query processing.

To work with data, a DBMS must retrieve the data from _____ and place them in _____.

One of the main functions of a database system is to provide timely answers to end users.

A system will perform best when its hardware and software resources are _____.

A table space has the same meaning as a file extent.

The B-tree index is used mainly in tables in which column values repeat a relatively small number of times.

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

A(n)_____ is an index based on a specific SQL function or expression.

The data cache is where the data read from the database data files are stored _____ the data have been read or _____ the data are written to the database data files.

An index scan is less efficient than a full table scan.

______ helps provide a balance between performance and fault tolerance.

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

The _____ segment table space is used for transaction-recovery purposes.

In the context of RAID levels, _____ refers to writing the same data blocks to separate drives.

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