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

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS

E) All of the above
F) B) and C)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

Good database performance is easy to evaluate.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

When moving data from permanent storage to RAM,an I/O disk operation retrieves:

is a measure of the likelihood that an index will be used in query processing.

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

Automatic query optimization means that the:

RAID systems use a single disk to create storage volumes.

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

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

The primary factor in determining the most efficient access plan is the I/O cost.

_________is evaluated based on client perspective.

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

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 .

The DBMS the data and sends the result set back to the client.

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

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

Good database performance starts with good database design.

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