Exam 11: Database Performance Tuning and Query Optimization

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

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

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

Using index characteristics,a database designer can determine the best type of index to use.

A data file can contain rows from a single table alone.

A is good for simple and fast lookup operations based on equality conditions.

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

The table space is the most frequently accessed table space and should be stored in its own volume.

Which of the following is the first step of query processing at the DBMS server end?

The SQL execution activities are performed by the query optimizer.

How can queries be written to perform the fastest when equality and inequality comparisons are needed?

Bitmap indexes tend to use less space than a because they use bits instead of bytes to store their data.

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

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

To work with data,the DBMS must retrieve the data from permanent storage and place it in RAM.

The LIKE conditional operator is used by the OPERAND1.

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

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

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

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