Exam 11: Database Performance Tuning and Query Optimization

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

DBMS query processing has ____________________ phases.

On the server side,the DBMS 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 that goal are commonly referred to as ____ tuning.

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

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

Why do we need to optimize a DBMS with SQL performance tuning,even though they automatically optimize SQL queries?

The DBMS ____ the SQL query using the chosen execution plan.

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

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

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 data cache caches system catalog data and the contents of the indexes.

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

The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.

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

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

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

Character field comparisons are faster than numeric,date,and NULL comparisons.

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

A(n)__________________ request is a low-level (read or write)data access operation to/from computer devices.

____________________ is a measure of how likely an index will be used in query processing.