Question 1

A(n) ____________________ request is a low-level (read or write) data access operation to/from computer devices.

Accepted Answer

The answer of A(n) ____________________ request is a low-level (read...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

____________________ is another name for table space.

Accepted Answer

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

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

The system will perform best when its hardware and software resources are ____________________.

Accepted Answer

The answer of The system will perform best when its...

Question 10

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 11

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 12

Character field comparisons are faster than numeric, date, and NULL comparisons.

Accepted Answer

A) True 
 B)False

Question 13

____ is/are the central activity during the parsing phase in query processing.

Accepted Answer

A)  Database statistics 
B)  Data sparsity 
C)  SQL query 
D)  Query optimization 
A)  Database statistics 
B)  Data sparsity 
C)  SQL query 
D)  Query optimization

Question 14

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

Question 15

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 16

RAID systems use a single disk to create storage volumes.

Accepted Answer

A) True 
 B)False

Question 17

The DBMS ____ the SQL query using the chosen execution plan.

Accepted Answer

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

Question 18

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

A(n) ____________________ request is a low-level (read or write) data access operation to/from computer devices.

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

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

____________________ is another name for table space.

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

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

All data in a database are stored in ____ files.

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

The system will perform best when its hardware and software resources are ____________________.

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

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

Character field comparisons are faster than numeric, date, and NULL comparisons.

____ is/are the central activity during the parsing phase in query processing.

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

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.

RAID systems use a single disk to create storage volumes.

The DBMS ____ the SQL query using the chosen execution plan.

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

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

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

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

A(n) ____________________ request is a low-level (read or write) data access operation to/from computer devices.

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

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

____________________ is another name for table space.

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

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

All data in a database are stored in ____ files.

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

The system will perform best when its hardware and software resources are ____________________.

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

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

Character field comparisons are faster than numeric, date, and NULL comparisons.

____ is/are the central activity during the parsing phase in query processing.

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

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.

RAID systems use a single disk to create storage volumes.

The DBMS ____ the SQL query using the chosen execution plan.

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

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

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

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

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.