Question 1

The must be set large enough to permit as many data requests to be serviced from cache as possible.

Accepted Answer

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

Question 2

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)  Delivering 
A)  Executing 
B)  Parsing 
C)  Fetching 
D)  Delivering

Question 3

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 4

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

Accepted Answer

A)  after; before 
B)  after; after 
C)  before; before 
D)  before; after 
A)  after; before 
B)  after; after 
C)  before; before 
D)  before; after

Question 5

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

Accepted Answer

Query optimization is the central activi

Question 6

DBMS query processing has phases.

Accepted Answer

The answer of DBMS query processing has phases....

Question 7

One of the main functions of a database system is to provide timely answers to end users.

Accepted Answer

A) True 
 B)False

Question 8

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)  buffer cache 
C)  supplements 
D)  extends 
A)  procedure cache 
B)  buffer cache 
C)  supplements 
D)  extends

Question 9

is an index based on a specific SQL function or expression.

Accepted Answer

function-b

Question 10

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 11

The table space is used to store the data dictionary tables.

Accepted Answer

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

Question 12

The table space is used for transaction-recovery purposes.

Accepted Answer

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

Question 13

Working with data in the data cache is many times faster than working with data in the data files.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  an entire table. 
B)  an entire physical disk block. 
C)  only the row containing the attribute requested. 
D)  only the attribute which was requested. 
A)  an entire table. 
B)  an entire physical disk block. 
C)  only the row containing the attribute requested. 
D)  only the attribute which was requested.

Question 15

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 16

Automatic query optimization means that the:

Accepted Answer

A)  optimization takes place at compilation time by the programmer. 
B)  DBMS finds the most cost-effective access path without user intervention. 
C)  optimization process is scheduled and selected by the end user or programmer. 
D)  database access strategy is defined when the program is executed. 
A)  optimization takes place at compilation time by the programmer. 
B)  DBMS finds the most cost-effective access path without user intervention. 
C)  optimization process is scheduled and selected by the end user or programmer. 
D)  database access strategy is defined when the program is executed.

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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)  listener 
A)  procedure cache 
B)  table space 
C)  data cache 
D)  listener

Question 20

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

The must be set large enough to permit as many data requests to be serviced from cache as possible.

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

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

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

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

DBMS query processing has phases.

One of the main functions of a database system is to provide timely answers to end users.

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 .

is an index based on a specific SQL function or expression.

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

The table space is used to store the data dictionary tables.

The table space is used for transaction-recovery purposes.

Working with data in the data cache is many times faster than working with data in the data files.

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

The SQL execution activities are performed by the query optimizer.

Automatic query optimization means that the:

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

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

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

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

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

The must be set large enough to permit as many data requests to be serviced from cache as possible.

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

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

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

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

DBMS query processing has phases.

One of the main functions of a database system is to provide timely answers to end users.

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 .

is an index based on a specific SQL function or expression.

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

The table space is used to store the data dictionary tables.

The table space is used for transaction-recovery purposes.

Working with data in the data cache is many times faster than working with data in the data files.

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

The SQL execution activities are performed by the query optimizer.

Automatic query optimization means that the:

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

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

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

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

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