Question 1

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  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.

Accepted Answer

A)  client and server 
B)  database 
C)  SQL performance 
D)  DBMS performance 
A)  client and server 
B)  database 
C)  SQL performance 
D)  DBMS performance D

Question 4

Good database performance starts with good database design.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of The ____________________ cache is a shared, reserved...

Question 6

The SQL execution activities are performed by the query optimizer.

Accepted Answer

A) True 
 B)False

Question 7

If there is no index, the DBMS will perform a ____ scan.

Accepted Answer

A)  loop 
B)  range 
C)  row ID table access 
D)  full table 
A)  loop 
B)  range 
C)  row ID table access 
D)  full table

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

Question 9

When setting optimizer hints, ____ instructs the optimizer to minimize the time it takes to process the first set of rows, that is, to minimize the time it takes to return only the first set of rows in the query result set. This hint is generally used for interactive 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 10

The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

Accepted Answer

The answer of The ____________________ analyzes the SQL query and...

Question 11

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

Accepted Answer

Equality comparisons are generally faste

Question 12

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

Accepted Answer

Query optimization is the central activi

Question 13

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 14

The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

Accepted Answer

A)  buffer cache 
B)  procedure cache 
C)  SQL cache 
D)  permanent storage 
A)  buffer cache 
B)  procedure cache 
C)  SQL cache 
D)  permanent storage

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Use __________________________________________________ to provide balance between performance and fault tolerance.

Accepted Answer

RAID
redundant array

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.

Good database performance starts with good database design.

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

The SQL execution activities are performed by the query optimizer.

If there is no index, the DBMS will perform a ____ scan.

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

When setting optimizer hints, ____ instructs the optimizer to minimize the time it takes to process the first set of rows, that is, to minimize the time it takes to return only the first set of rows in the query result set. This hint is generally used for interactive mode processes.

The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

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

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

The ____ cache stores the most recently executed SQL statements.

The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

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

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

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

Use __________________________________________________ to provide balance between performance and fault tolerance.

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.

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Databases for Decision Support

Filters

Exam 14: Managing Database and Sql Performance

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

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

On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.

Good database performance starts with good database design.

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

The SQL execution activities are performed by the query optimizer.

If there is no index, the DBMS will perform a ____ scan.

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

When setting optimizer hints, ____ instructs the optimizer to minimize the time it takes to process the first set of rows, that is, to minimize the time it takes to return only the first set of rows in the query result set. This hint is generally used for interactive mode processes.

The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

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

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

The ____ cache stores the most recently executed SQL statements.

The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

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

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

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

Use __________________________________________________ to provide balance between performance and fault tolerance.

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.

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Databases for Decision Support

Filters