FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Database Performance Tuning and Query Optimization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

The _____ segment table space is used for transaction-recovery purposes.

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

Summarize the steps required to formulate a query.

_____ refers to the number of different values a column could possibly have.

______ helps provide a balance between performance and fault tolerance.

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

A table space has the same meaning as a file extent.

The B-tree index is used mainly in tables in which column values repeat a relatively small number of times.

The _____ 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.

A system will perform best when its hardware and software resources are _____.

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.

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

To work with data, a DBMS must retrieve the data from _____ and place them in _____.

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

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) _____ plan.

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

A(n)_____ is an index based on a specific SQL function or expression.

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

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