Question 1

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

system

Question 4

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segment

Question 5

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

Accepted Answer

The answer of The system will perform best when its...

Question 6

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

Accepted Answer

The answer of ____________________ are ordered sets of values that...

Question 7

Good database performance is easy to evaluate.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)   buffer cache
B)   procedure cache
C)   SQL cache
D)   permanent storage

Question 9

The data cache is where the data read from the database data files are stored ____ the data have been read or ____ the data are written to the database data files.

Accepted Answer

A)   after,before
B)   after,after
C)   before,before
D)   before,after

Question 10

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

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segment

Question 11

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

Accepted Answer

The answer of The ____________________ analyzes the SQL query and...

Question 12

The SQL cache stores the end-user written SQL.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of How can queries be written to perform...

Question 14

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

Accepted Answer

The answer of How should storage volumes be allocated for...

Question 15

The ____ table space is used for transaction-recovery purposes.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segment

Question 16

Indexes are very useful in small tables or tables with low sparsity.

Accepted Answer

A) True 
 B)False

Question 17

List and describe some typical DBMS processes.

Accepted Answer

The answer of List and describe some typical DBMS processes....

Question 18

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.

Accepted Answer

A)   client and server
B)   database
C)   SQL performance
D)   DBMS performance

Question 19

A DBA determines the initial size of the data files that make up the database; however,as required,the data files can automatically expand in predefined increments known as ____.

Accepted Answer

A)   procedure cache
B)   file group
C)   data files
D)   extends

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 11: Database Performance Tuning and Query Optimization

The SQL execution activities are performed by the query optimizer.

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

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

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

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

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

Good database performance is easy to evaluate.

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

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

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

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

The SQL cache stores the end-user written SQL.

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

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

The ____ table space is used for transaction-recovery purposes.

Indexes are very useful in small tables or tables with low sparsity.

List and describe some typical DBMS processes.

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 DBA determines the initial size of the data files that make up the database; however,as required,the data files can automatically expand in predefined increments known as ____.

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