Question 1

____________________ are ordered sets of values that are crucial in speeding up data access.

Accepted Answer

The answer of ____________________ are ordered sets of values that...

Question 2

On the client side, the objective is to generate a SQL query that returns the correct answer in the least amount of time, using the minimum amount of resources at the server end. 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

Question 3

All transaction management commands are processed during the parsing and execution phases of query processing.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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

Accepted Answer

Assign separate data files in separate s

Question 6

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 7

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

Accepted Answer

The answer of A conditional expression is normally expressed within...

Question 8

____________________ is a measure of how likely an index will be used in query processing.

Accepted Answer

The answer of ____________________ is a measure of how likely...

Question 9

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 10

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

____________________ are ordered sets of values that are crucial in speeding up data access.

On the client side, the objective is to generate a SQL query that returns the correct answer in the least amount of time, using the minimum amount of resources at the server end. The activities required to achieve that goal are commonly referred to as ____ tuning.

All transaction management commands are processed during the parsing and execution phases of query processing.

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.

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

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

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

____________________ is a measure of how likely an index will be used in query processing.

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

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

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

____________________ are ordered sets of values that are crucial in speeding up data access.

On the client side, the objective is to generate a SQL query that returns the correct answer in the least amount of time, using the minimum amount of resources at the server end. The activities required to achieve that goal are commonly referred to as ____ tuning.

All transaction management commands are processed during the parsing and execution phases of query processing.

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.

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

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

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

____________________ is a measure of how likely an index will be used in query processing.

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

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

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