Exam 11: Database Performance Tuning and Query Optimization

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

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

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

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

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

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.

____________________ is another name for table space.

The SQL cache stores the end-user written SQL.

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

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

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

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

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

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

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

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

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

A(n)____ is a logical grouping of several data files that store data with similar characteristics.

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

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.