Question 1

DBMS query processing has phases.

Accepted Answer

The answer of DBMS query processing has phases....

Question 2

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) plan.

Accepted Answer

The answer of Once an SQL statement is transformed, the...

Question 3

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; afterE) B) and D)
F) B) and C)

Question 4

Automatic query optimization means that the:

Accepted Answer

A)   optimization takes place at compilation time by the programmer.
B)   DBMS finds the most cost-effective access path without user intervention.
C)   optimization process is scheduled and selected by the end user or programmer.
D)   database access strategy is defined when the program is executed.E) A) and B)
F) B) and C)

Question 5

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

Accepted Answer

A)   procedure cache
B)   table space
C)   data cache
D)   listenerE) A) and B)
F) All of the above

Question 6

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

Accepted Answer

Query optimization is the central activi...

Question 7

Working with data in the data cache is many times faster than working with data in the data files.

Accepted Answer

A) True 
 B)False

Question 8

The must be set large enough to permit as many data requests to be serviced from cache as possible.

Accepted Answer

A)   data cache
B)   SQL cache
C)   sort cache
D)   optimizer modeE) A) and D)
F) B) and C)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 11

is an index based on a specific SQL function or expression.

Accepted Answer

function-b...

Question 12

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

Accepted Answer

A)   buffer cache
B)   procedure cache
C)   data cache
D)   permanent storageE) B) and C)
F) C) and D)

Question 13

When moving data from permanent storage to RAM, an I/O disk operation retrieves:

Accepted Answer

A)   an entire table.
B)   an entire physical disk block.
C)   only the row containing the attribute requested.
D)   only the attribute which was requested.E) C) and D)
F) A) and B)

Question 14

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)   buffer cache
C)   supplements
D)   extendsE) A) and B)
F) All of the above

Question 15

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

Accepted Answer

A)   Executing
B)   Parsing
C)   Fetching
D)   DeliveringE) B) and D)
F) B) and C)

Question 16

The table space is used for transaction-recovery purposes.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) B) and D)
F) None of the above

Question 17

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

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) A) and D)
F) B) and C)

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of The table space is the most frequently...

Exam 11: Database Performance Tuning and Query Optimization

DBMS query processing has phases.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) plan.

Correct AnswerverifiedShow Answer

The SQL execution activities are performed by the query optimizer.

Correct AnswerverifiedShow Answer

is an index based on a specific SQL function or expression.

Correct Answerverifiedfunction-b...View AnswerShow Answer

Automatic query optimization means that the:

Correct AnswerverifiedShow Answer

The must be set large enough to permit as many data requests to be serviced from cache as possible.

Correct AnswerverifiedShow Answer

When moving data from permanent storage to RAM, an I/O disk operation retrieves:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedQuery optimization is the central activi...View AnswerShow Answer

The table space is used for transaction-recovery purposes.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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 .

Correct AnswerverifiedShow Answer

Working with data in the data cache is many times faster than working with data in the data files.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
function-b...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Query optimization is the central activi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified