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

The majority of primary memory resources will be allocated to the ____ cache.

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

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

A data file can only contain rows from one single table.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

On the client side,the objective is to generate a SQL query that returns the correct answer in the least amount of time,using the minimum amount of resources at the server end.The activities required to achieve that goal are commonly referred to as ____ tuning.

The ____ cache stores the most recently executed SQL statements.

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

The system will perform best when its hardware and software resources are ____________________.

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

____ is/are the central activity during the parsing phase in query processing.