Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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

Question 4

In the context of RAID levels,refers to writing the same data blocks to separate drives.

Accepted Answer

A)  striping
B)  mirroring
C)  partitioning
D)  aggregatingE) A) and C)
F) B) and C)

Question 5

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 6

A data file can contain rows from a single table alone.

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

Database activities can be divided into those taking place either on the client side or on the server side.

Accepted Answer

The answer of Database activities can be divided into those...

Question 9

How can queries be written to perform the fastest when equality and inequality comparisons are needed?

Accepted Answer

Equality comparisons are generally faste...

Question 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

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

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 15

A is good for simple and fast lookup operations based on equality conditions.

Accepted Answer

The answer of A is good for simple and fast...

Question 16

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

Question 17

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

Question 18

Why do we need to optimize a DBMS with SQL performance tuning,even though they automatically optimize SQL queries?

Accepted Answer

There is considerable room for improveme...

Question 19

The LIKE conditional operator is used by the OPERAND1.

Accepted Answer

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

Question 20

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

Accepted Answer

A) True 
 B)False

Exam 11: Database Performance Tuning and Query Optimization

Database activities can be divided into those taking place either on the client side or on the server side.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

The LIKE conditional operator is used by the OPERAND1.

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

In the context of RAID levels,refers to writing the same data blocks to separate drives.

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

A data file can contain rows from a single table alone.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How can queries be written to perform the fastest when equality and inequality comparisons are needed?

Correct AnswerverifiedEquality comparisons are generally faste...View AnswerShow Answer

The SQL execution activities are performed by the query optimizer.

Correct AnswerverifiedShow Answer

A is good for simple and fast lookup operations based on equality conditions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Why do we need to optimize a DBMS with SQL performance tuning,even though they automatically optimize SQL queries?

Correct AnswerverifiedThere is considerable room for improveme...View AnswerShow 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
Equality comparisons are generally faste...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There is considerable room for improveme...
View Answer