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 21

Short Answer

Review LaterAdd Note

Review Later

____________________ are special instructions for the optimizer that are embedded inside the SQL command text.

Correct Answer

verified

Show Answer

Question 22

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) A) and B)
F) B) and C)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

The DBMS ____ the SQL query and chooses the most efficient access/execution plan.

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

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

If there is no index,the DBMS will perform a ____ scan.

Character field comparisons are faster than numeric,date,and NULL comparisons.

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.

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

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

DBMS query processing has ____________________ phases.

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

The data cache caches system catalog data and the contents of the indexes.

On the server side,the DBMS environment must be properly configured to respond to clients requests in the fastest way possible,while making optimum use of existing resources.The activities required to achieve that goal are commonly referred to as ____ tuning.

The DBMS ____ the SQL query using the chosen execution plan.

____________________ is a measure of how likely an index will be used in query processing.

End users and the DBMS interact through the use of ____________________ to generate information.

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

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

The ____ table space is used to store end-user data.