Question 1

Knowing the sparsity of a column helps you decide whether the use of is appropriate.

Accepted Answer

A)   query processing
B)   query optimization
C)   an index
D)   a full table scanE) A) and C)
F) C) and D)

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of The cache is a shared, reserved memory...

Question 6

In RAID level 5,:

Accepted Answer

A)   the data and the parity data are striped across separate drives.
B)   the data blocks are spread over separate drives and are duplicated.
C)   the array requires a minimum of two drives and is known as a striped array.
D)   the array requires a minimum of five drives and is known as duplexing.E) A) and B)
F) None of the above

Question 7

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

Accepted Answer

A) True 
 B)False

Question 8

End users and the DBMS interact through the use of to generate information.

Accepted Answer

The answer of End users and the DBMS interact through...

Question 9

From the performance point of view, databases eliminate disk access bottlenecks.

Accepted Answer

A)   RAID
B)   distributed
C)   index-organized
D)   in-memoryE) None of the above
F) A) and D)

Question 10

are special instructions for the optimizer that are embedded inside the SQL command text.

Accepted Answer

The answer of are special instructions for the optimizer that...

Question 11

On the server side, the database environment must be properly configured to respond to clients' requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve this goal are commonly referred to as tuning.

Accepted Answer

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

Question 12

Summarize the steps required to formulate a query.

Accepted Answer

Queries are usually written to answer qu...

Question 13

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 14

An index scan is less efficient than a full table scan.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

The LIKE conditional operator is used by the OPERAND1.

Accepted Answer

A)   P_PRICE
B)   V_STATE
C)   P_QOH
D)   V_CONTACTE) C) and D)
F) B) and C)

Question 17

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) None of the above

Question 18

In the context of RAID levels, striped arrays provide:

Accepted Answer

A)  	increased read performance and fault tolerance
B)  	increased fault tolerance but decreased performance.
C)  	increased read performance but no fault tolerance.	
D)  	neither fault tolerance nor good performanceE) All of the above
F) A) and B)

Question 19

helps provide a balance between performance and fault tolerance.

Accepted Answer

RAID
Redundant array...

Question 20

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

Accepted Answer

A)   procedure caches
B)   file groups
C)   data caches
D)   operation modesE) A) and C)
F) B) and C)

Exam 11: Database Performance Tuning and Query Optimization

An index scan is less efficient than a full table scan.

Correct AnswerverifiedShow Answer

Summarize the steps required to formulate a query.

Correct AnswerverifiedQueries are usually written to answer qu...View AnswerShow Answer

are special instructions for the optimizer that are embedded inside the SQL command text.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

From the performance point of view, databases eliminate disk access bottlenecks.

Correct AnswerverifiedShow Answer

The LIKE conditional operator is used by the OPERAND1.

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

In the context of RAID levels, striped arrays provide:

Correct AnswerverifiedShow Answer

In RAID level 5,:

Correct AnswerverifiedShow Answer

On the server side, the database environment must be properly configured to respond to clients' requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve this goal are commonly referred to as tuning.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

helps provide a balance between performance and fault tolerance.

Correct AnswerverifiedRAIDRedundant array...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The cache 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

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

Correct AnswerverifiedShow Answer

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

Correct AnswerverifiedShow Answer

End users and the DBMS interact through the use of to generate information.

Correct AnswerverifiedShow Answer

Knowing the sparsity of a column helps you decide whether the use of is appropriate.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Queries are usually written to answer qu...
View 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
RAID
Redundant array...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified