Question 1

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 2

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The ____ table space is used to store end-user data.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) A) and B)
F) A) and C)

Question 5

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

Accepted Answer

system

Question 6

Good database performance starts with good database design.

Accepted Answer

A) True 
 B)False

Question 7

To work with the data,the DBMS must retrieve the data from the ____ and place it in the ____.

Accepted Answer

A)   data files, procedure cache
B)   data files, data cache
C)   temporary files, RAM
D)   temporary files, procedure cacheE) A) and D)
F) None of the above

Question 8

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 9

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)   file group
C)   data files
D)   extendsE) B) and C)
F) A) and C)

Question 10

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

Accepted Answer

A) True 
 B)False  True

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

Assign separate data files in separate s...

Question 14

Indexes are very useful in small tables or tables with low sparsity.

Accepted Answer

A) True 
 B)False

Question 15

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) None of the above
F) A) and B)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

Equality comparisons are generally faster than inequality comparisons.For example,P_PRICE = 10.00 is processed faster because the DBMS can do a direct search using the index in the column.If there are no exact matches,the condition is evaluated as false.However,if you use an inequality symbol (>,>=,<,<=),the DBMS must perform additional processing to complete the request,because there will almost always be more "greater than" or "less than" values in the index than "equal" values.With the exception of NULL,the slowest of all comparison operators is LIKE with wildcard symbols,as in V_CONTACT LIKE "%glo%".Also,using the "not equal" symbol (<>)yields slower searches,especially when the sparsity of the data is high-that is,when there are many more different values than there are equal values.

Question 20

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

Accepted Answer

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

Exam 11: Database Performance Tuning and Query Optimization

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The ____ table space is used to store end-user data.

Correct Answer
verified

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

Correct Answer
verified
system

Good database performance starts with good database design.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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 Answer
verified

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

Correct Answer
verified
True

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

Correct Answer
verified

RAID systems use a single disk to create storage volumes.

Correct Answer
verified

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

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

Indexes are very useful in small tables or tables with low sparsity.

Correct Answer
verified

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The SQL execution activities are performed by the query optimizer.

Correct Answer
verified

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

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

Correct Answer
verified

Exam 11: Database Performance Tuning and Query Optimization

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

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 data cache caches system catalog data and the contents of the indexes.

Correct AnswerverifiedShow Answer

The ____ table space is used to store end-user data.

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedsystem

Good database performance starts with good database design.

Correct AnswerverifiedShow Answer

To work with the data,the DBMS must retrieve the data from the ____ and place it in the ____.

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

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

RAID systems use a single disk to create storage volumes.

Correct AnswerverifiedShow Answer

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

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

Indexes are very useful in small tables or tables with low sparsity.

Correct AnswerverifiedShow Answer

The ____ table space is used as a temporary storage area for merge,sort,or set aggregate operations.

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

The SQL execution activities are performed by the query optimizer.

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
system

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified