Exam 11: Database Performance Tuning and Query Optimization

In alevel _____ RAID, the data and the parity data is striped across separate drives.

Describe query optimization and the modes that an optimizer can operate in.

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.

If there is no index, the DBMS will perform a _____ scan.

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.

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

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

_____ is a measure of the likelihood that an index will be used in query processing.

_____ is another name for table space.

The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

_____ is evaluated based on client perspective.

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

_____ is the central activity during the parsing phase in query processing.

Most current-generation relational DBMSs perform automatic query optimization at the client end.

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

When moving data from permanent storage to RAM, an I/O disk operation retrieves a(n):

The SQL execution activities are performed by the query optimizer.

Indexes do not facilitate join operations.

Fully equivalent means that the optimized query results are always the same as the original query.

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