Question 1

Indexes do not facilitate join operations.

Accepted Answer

A) True 
 B)False

Question 2

When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.

Accepted Answer

A)   ALL_ROWS
B)   FIRST_ROWS
C)   INDEX(P_QOH_NDX) 
D)   OPTIMIZATION_ROWSE) A) and B)
F) A) and D)

Question 3

Use _____________________________________________ to provide balance between performance and fault tolerance.

Accepted Answer

RAID
redundant array...

Question 4

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   procedure cache
B)   file group
C)   data files
D)   extendsE) All of the above
F) B) and D)

Question 7

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) C) and D)
F) A) and C)

Question 8

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.

Accepted Answer

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

Question 9

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

Accepted Answer

A)   data
B)   SQL
C)   sort
D)   optimizerE) B) and D)
F) B) and C)

Question 10

When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.

Accepted Answer

A)   ALL_ROWS
B)   FIRST_ROWS
C)   INDEX(P_QOH_NDX) 
D)   OPTIMIZATION_ROWSE) B) and D)
F) A) and C)

Question 11

The ____ cache stores the most recently executed SQL statements.

Accepted Answer

A)   data
B)   SQL
C)   sort
D)   optimizerE) None of the above
F) All of the above

Question 12

One measure that determines the need for an index is the ____ of the column you want to index.____ refers to the number of different values a column could possibly have.

Accepted Answer

A)   Database statistics
B)   Data sparsity
C)   Primary keys
D)   Query optimizationE) B) and C)
F) A) and B)

Question 13

The DBMS ____ the data and sends the result set back to the client.

Accepted Answer

A)   parses
B)   executes
C)   fetches
D)   processesE) All of the above
F) A) and B)

Question 14

All data in a database are stored in ____ files.

Accepted Answer

A)   table
B)   data
C)   RAM
D)   systemE) All of the above
F) A) and B)

Question 15

To generate database object statistics manually,you could use the following syntax:____.

Accepted Answer

A) ANALYZE object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS;E) All of the above F) A) and B)

Question 16

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

Accepted Answer

A)   data
B)   SQL
C)   sort
D)   optimizerE) B) and C)
F) A) and B)

Question 17

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

Accepted Answer

Query optimization is the central activi...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

____________________ is another name for table space.

Accepted Answer

The answer of ____________________ is another name for table space....

Question 20

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 DBMS...

Exam 11: Database Performance Tuning and Query Optimization

RAID systems use a single disk to create storage volumes.

Correct AnswerverifiedShow Answer

____________________ is another name for table space.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ cache stores the most recently executed SQL statements.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Indexes do not facilitate join operations.

Correct AnswerverifiedShow Answer

All data in a database are stored in ____ files.

Correct AnswerverifiedShow Answer

When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.

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

When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.

Correct AnswerverifiedShow Answer

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

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

One measure that determines the need for an index is the ____ of the column you want to index.____ refers to the number of different values a column could possibly have.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To generate database object statistics manually,you could use the following syntax:____.

Correct AnswerverifiedShow Answer

Use _____________________________________________ to provide balance between performance and fault tolerance.

Correct AnswerverifiedRAIDredundant array...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The DBMS ____ the data and sends the result set back to the client.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

One measure that determines the need for an index is the of the column you want to index. refers to the number of different values a column could possibly have.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
RAID
redundant array...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified