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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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

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

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

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

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

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

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

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.

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

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

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

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

Summarize the steps required to formulate a query.

______ helps provide a balance between performance and fault tolerance.

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

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

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