Question 1

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 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

system

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 6

Good database performance starts with good database design.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  parses 
B)  executes 
C)  fetches 
D)  processes 
A)  parses 
B)  executes 
C)  fetches 
D)  processes

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 segment 
A)  system 
B)  user data 
C)  temporary 
D)  rollback segment

Question 13

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 cache 
A)  data files, procedure cache 
B)  data files, data cache 
C)  temporary files, RAM 
D)  temporary files, procedure cache

Question 14

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)  extends 
A)  procedure cache 
B)  file group 
C)  data files 
D)  extends

Question 15

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

Accepted Answer

Assign separate data files in separate s

Question 16

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)  extends 
A)  procedure caches 
B)  file groups 
C)  data files 
D)  extends

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  system 
B)  user data 
C)  temporary 
D)  rollback segment 
A)  system 
B)  user data 
C)  temporary 
D)  rollback segment

Question 20

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

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

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

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

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

RAID systems use a single disk to create storage volumes.

Good database performance starts with good database design.

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

The SQL execution activities are performed by the query optimizer.

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

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

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

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

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

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

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

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

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

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

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

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 11: Database Performance Tuning and Query Optimization

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

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

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

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

RAID systems use a single disk to create storage volumes.

Good database performance starts with good database design.

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

The SQL execution activities are performed by the query optimizer.

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

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

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

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

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

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

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

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

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

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

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

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

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