Question 1

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

Accepted Answer

A)   entire table.
B)   entire physical disk block.
C)   single row containing the attribute requested.
D)   single attribute requested only.E) None of the above
F) A) and C)

Question 2

Indexes do not facilitate join operations.

Accepted Answer

A) True 
 B)False

Question 3

_____ is the central activity during the parsing phase in query processing.

Accepted Answer

A)   Clustering
B)   Partitioning
C)   Query validation
D)   Query optimizationE) All of the above
F) B) and C)

Question 4

If there is no index, the DBMS will perform a _____ scan.

Accepted Answer

A)   loop
B)   range
C)   row ID table access
D)   full tableE) C) and D)
F) B) and D)

Question 5

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

Query optimization is the central activi...

Question 8

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

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

Question 10

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

Question 11

_____ is another name for table space.

Accepted Answer

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

Question 12

_____ is evaluated based on client perspective.

Accepted Answer

SQL perfor...

Question 13

In alevel _____ RAID, the data and the parity data is striped across separate drives.

Accepted Answer

The answer of In alevel _____ RAID, the data and...

Question 14

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

Question 15

_____ is a measure of the likelihood that an index will be used in query processing.

Accepted Answer

The answer of _____ is a measure of the likelihood...

Question 16

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Most current-generation relational DBMSs perform automatic query optimization at the client end.

Accepted Answer

A) True 
 B)False

Question 20

In standard SQL, the optimizer hintFIRST_ROWS is generally used for _____ mode processes.

Accepted Answer

A)   batch
B)   interactive
C)   transaction
D)   real-timeE) B) and C)
F) A) and D)

Exam 11: Database Performance Tuning and Query Optimization

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

Correct AnswerverifiedShow Answer

In alevel _____ RAID, the data and the parity data is striped across separate drives.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ is the central activity during the parsing phase in query processing.

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

The SQL execution activities are performed by the query optimizer.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

If there is no index, the DBMS will perform a _____ scan.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ is a measure of the likelihood that an index will be used in query processing.

Correct AnswerverifiedShow Answer

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

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

Most current-generation relational DBMSs perform automatic query optimization at the client end.

Correct AnswerverifiedShow Answer

_____ is another name for table space.

Correct AnswerverifiedShow Answer

Indexes do not facilitate join operations.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ is evaluated based on client perspective.

Correct AnswerverifiedSQL perfor...View AnswerShow Answer

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

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

In standard SQL, the optimizer hintFIRST_ROWS is generally used for _____ mode processes.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
SQL perfor...
View Answer

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

Correct Answer
verified