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 1

Multiple Choice

Review LaterAdd Note

Review Later

The ____ table space is used to store the data dictionary tables.

A) system
B) user data
C) temporary
D) rollback segment

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

List and describe some typical DBMS processes.

Correct Answer

verified

Listener.The listener process listens fo...

View Answer

Show Answer

Question 3

True/False

Review LaterAdd Note

The SQL cache stores the end-user written SQL.

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

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.

Indexes are very useful in small tables or tables with low sparsity.

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

The system will perform best when its hardware and software resources are ____________________.

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

On the client side,the objective is to generate a SQL query that returns the correct answer in the least amount of time,using the minimum amount of resources at the server end.The activities required to achieve that goal are commonly referred to as ____ tuning.

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

The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

The SQL execution activities are performed by the query optimizer.

How should storage volumes be allocated for indexes,system,and high-usage tables?

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

____________________ are ordered sets of values that are crucial in speeding up data access.

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

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

A DBA determines the initial size of the data files that make up the database; however,as required,the data files can automatically expand in predefined increments known as ____.

Good database performance is easy to evaluate.