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

True/False

Review LaterAdd Note

Review Later

The SQL execution activities are performed by the query optimizer.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

A system table space,a user data table space,an index table space,and a temporary table space are examples of _____.

A) procedure caches
B) file groups
C) data caches
D) operation modes

E) B) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Essay

Review LaterAdd Note

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

A data file can contain rows from a single table alone.

Which of the following is the first step of query processing at the DBMS server end?

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

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

A is good for simple and fast lookup operations based on equality conditions.

The purpose of an I/O operation is to move data to and from different computer components or devices.

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

The LIKE conditional operator is used by the OPERAND1.

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

Using index characteristics,a database designer can determine the best type of index to use.

From the performance point of view,databases eliminate disk access bottlenecks.

A(n) is a logical grouping of several data files that store data with similar characteristics.

Bitmap indexes tend to use less space than a because they use bits instead of bytes to store their data.

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

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

In the context of RAID levels,refers to writing the same data blocks to separate drives.

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.