Exam 11: Database Performance Tuning and Query Optimization

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

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

Summarize the steps required to formulate a query.

End users and the DBMS interact through the use of to generate information.

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

helps provide a balance between performance and fault tolerance.

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

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

are ordered sets of values that are crucial in speeding up data access.

From the performance point of view, databases eliminate disk access bottlenecks.

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

The DBMS the SQL query and chooses the most efficient access/execution plan.

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

The data cache caches system catalog data and the contents of the indexes.

The DBMS the data and sends the result set back to the client.

The LIKE conditional operator is used by the OPERAND1.

On the server side, the database environment must be properly configured to respond to clients' requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve this goal are commonly referred to as tuning.

In RAID level 5,:

In the context of RAID levels, striped arrays provide:

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