Question 1

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

Accepted Answer

Assign separate data files in separate s...

Question 2

A(n) _____ is good for simple and fast lookup operations based on equality conditions.

Accepted Answer

The answer of A(n) _____ is good for simple and...

Question 3

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) A) and B)
F) None of the above

Question 4

A(n) _____ tablestores the end-user data and the index data in consecutive locations on permanent storage.

Accepted Answer

index-orga...

Question 5

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 6

The data cache caches system catalog data and the contents of the indexes.

Accepted Answer

A) True 
 B)False

Question 7

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) All of the above
F) B) and D)

Question 8

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

Accepted Answer

query optimizer

Question 9

The primary factor in determining the most efficient access plan is the I/O cost.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False  True

Question 11

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.

Accepted Answer

A)   hash index
B)   sparse index
C)   B-tree index
D)   reverse indexE) None of the above
F) C) and D)

Question 12

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 13

_____ 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 14

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

Accepted Answer

A)   parses
B)   executes
C)   fetches
D)   processesE) A) and D)
F) A) and C)

Question 15

The LIKE conditional operator is used by the _____ OPERAND1.

Accepted Answer

A)   P_PRICE
B)   V_STATE
C)   P_QOH
D)   V_CONTACTE) None of the above
F) All of the above

Question 16

To generate database object statistics manually, following syntax should be used in Oracle:

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 17

The SQL cache stores the end-user written SQL.

Accepted Answer

A) True 
 B)False  False

Question 18

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) All of the above
F) B) and C)

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)   buffer cache
C)   supplements
D)   extentsE) A) and B)
F) B) and D)

Question 20

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

Accepted Answer

A)   client SQL
B)   database SQL
C)   SQL performance
D)   DBMS performanceE) C) and D)
F) A) and B)

Exam 11: Database Performance Tuning and Query Optimization

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

Correct AnswerverifiedAssign separate data files in separate s...View AnswerShow Answer

A(n) _____ is good for simple and fast lookup operations based on equality conditions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n) _____ tablestores the end-user data and the index data in consecutive locations on permanent storage.

Correct Answerverifiedindex-orga...View AnswerShow Answer

RAID systems use a single disk to create storage volumes.

Correct AnswerverifiedShow Answer

The data cache caches system catalog data and the contents of the indexes.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedquery optimizer

The primary factor in determining the most efficient access plan is the I/O cost.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The LIKE conditional operator is used by the _____ OPERAND1.

Correct AnswerverifiedShow Answer

To generate database object statistics manually, following syntax should be used in Oracle:

Correct AnswerverifiedShow Answer

The SQL cache stores the end-user written SQL.

Correct AnswerverifiedFalse

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

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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
Assign separate data files in separate s...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
index-orga...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
query optimizer

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified