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 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) query processing
B) query optimization
C) an index
D) a full table scan

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.

A) data cache
B) SQL cache
C) sort cache
D) optimizer mode

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

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

Maximizing disk contention is one of the general recommendations for the physical storage of databases.

When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that is, to minimize the time it takes to return the total number of rows in the query result set. This hint is generally used for batch mode processes.

List and describe some typical DBMS processes.

The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.

During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.

Good database performance is easy to evaluate.

DBMS query processing has _____ phases.

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

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

Automatic query optimization means that the:

The _____ process analyzes SQL queries and finds the most efficient way to access data.