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 41

Short Answer

Review LaterAdd Note

Review Later

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Essay

Review LaterAdd Note

How should storage volumes be allocated for indexes, system, and high-usage tables?

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

Most DBMSs operate in one of two optimization modes: cost-based or rule-based. Others automatically determine the ____ based on whether database statistics are available.

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.

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

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

The ____ table space is used to store the data dictionary tables.

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