FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Managing Database and Sql Performance

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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.

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

Describe query optimization and the modes that an optimizer can operate in.

The ____ cache stores the most recently executed SQL statements.

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

When setting optimizer hints, ____ instructs the optimizer to minimize the time it takes to process the first set of rows, that is, to minimize the time it takes to return only the first set of rows in the query result set. This hint is generally used for interactive mode processes.

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

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

The SQL execution activities are performed by the query optimizer.

Use __________________________________________________ to provide balance between performance and fault tolerance.

Good database performance starts with good database design.

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

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.

Most current-generation relational DBMSs perform automatic query optimization at the client end.