Question 1

A data file can only contain rows from one single table.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

Query optimization is the central activi

Question 3

The ____ cache stores the most recently executed SQL statements.

Accepted Answer

A)  data 
B)  SQL 
C)  sort 
D)  optimizer 
A)  data 
B)  SQL 
C)  sort 
D)  optimizer

Question 4

When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.

Accepted Answer

A)  ALL_ROWS 
B)  FIRST_ROWS 
C)  INDEX(P_QOH_NDX) 
D)  OPTIMIZATION_ROWS 
A)  ALL_ROWS 
B)  FIRST_ROWS 
C)  INDEX(P_QOH_NDX) 
D)  OPTIMIZATION_ROWS

Question 5

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

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 6

All data in a database are stored in ____ files.

Accepted Answer

A)  table 
B)  data 
C)  RAM 
D)  system 
A)  table 
B)  data 
C)  RAM 
D)  system

Question 7

One measure that determines the need for an index is the ____ of the column you want to index.____ refers to the number of different values a column could possibly have.

Accepted Answer

A)  Database statistics 
B)  Data sparsity 
C)  Primary keys 
D)  Query optimization 
A)  Database statistics 
B)  Data sparsity 
C)  Primary keys 
D)  Query optimization

Question 8

____________________ is another name for table space.

Accepted Answer

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

Question 9

Indexes do not facilitate join operations.

Accepted Answer

A) True 
 B)False

Question 10

Use _____________________________________________ to provide balance between performance and fault tolerance.

Accepted Answer

RAID
redundant array

Question 11

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 storage 
A)  buffer cache 
B)  procedure cache 
C)  data cache 
D)  permanent storage

Question 12

To generate database object statistics manually,you could use the following syntax:____.

Accepted Answer

A) ANALYZE object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS; A) ANALYZE

object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS;

Question 13

Most DBMSs operate in one of two optimization modes: cost-based or rule-based.Others automatically determine the ____ based on whether database statistics are available.

Accepted Answer

A)  data cache 
B)  SQL cache 
C)  sort cache 
D)  optimization mode 
A)  data cache 
B)  SQL cache 
C)  sort cache 
D)  optimization mode

Question 14

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

Accepted Answer

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

Question 15

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 16

When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.

Accepted Answer

A)  ALL_ROWS 
B)  FIRST_ROWS 
C)  INDEX(P_QOH_NDX) 
D)  OPTIMIZATION_ROWS 
A)  ALL_ROWS 
B)  FIRST_ROWS 
C)  INDEX(P_QOH_NDX) 
D)  OPTIMIZATION_ROWS

Question 17

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

Accepted Answer

A)  data 
B)  SQL 
C)  sort 
D)  optimizer 
A)  data 
B)  SQL 
C)  sort 
D)  optimizer

Question 18

Once an SQL statement is transformed,the DBMS creates what is commonly known as a(n)____________________ plan.

Accepted Answer

The answer of Once an SQL statement is transformed,the DBMS...

Question 19

The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

Accepted Answer

A)  data 
B)  SQL 
C)  sort 
D)  optimizer 
A)  data 
B)  SQL 
C)  sort 
D)  optimizer

Question 20

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

A data file can only contain rows from one single table.

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

The ____ cache stores the most recently executed SQL statements.

When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.

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

All data in a database are stored in ____ files.

One measure that determines the need for an index is the of the column you want to index. refers to the number of different values a column could possibly have.

____________________ is another name for table space.

Indexes do not facilitate join operations.

Use _____________________________________________ to provide balance between performance and fault tolerance.

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

To generate database object statistics manually,you could use the following syntax:____.

Most DBMSs operate in one of two optimization modes: cost-based or rule-based.Others automatically determine the ____ based on whether database statistics are available.

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

RAID systems use a single disk to create storage volumes.

When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.

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

Once an SQL statement is transformed,the DBMS creates what is commonly known as a(n)____________________ plan.

The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

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

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

A data file can only contain rows from one single table.

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

The ____ cache stores the most recently executed SQL statements.

When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.

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

All data in a database are stored in ____ files.

One measure that determines the need for an index is the ____ of the column you want to index.____ refers to the number of different values a column could possibly have.

____________________ is another name for table space.

Indexes do not facilitate join operations.

Use _____________________________________________ to provide balance between performance and fault tolerance.

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

To generate database object statistics manually,you could use the following syntax:____.

Most DBMSs operate in one of two optimization modes: cost-based or rule-based.Others automatically determine the ____ based on whether database statistics are available.

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

RAID systems use a single disk to create storage volumes.

When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.

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

Once an SQL statement is transformed,the DBMS creates what is commonly known as a(n)____________________ plan.

The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

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

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

One measure that determines the need for an index is the of the column you want to index. refers to the number of different values a column could possibly have.