Question 1

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

Accepted Answer

A)  Memory usage 
B)  CPU usage 
C)  Input/output contention 
D)  User interface design 
A)  Memory usage 
B)  CPU usage 
C)  Input/output contention 
D)  User interface design D

Question 2

With a one-key encryption standard,both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

Accepted Answer

A) True 
 B)False  True

Question 3

Guidelines for server security should include all of the following EXCEPT:

Accepted Answer

A)  securing the network between client and server. 
B)  guidelines for password lengths. 
C)  password naming conventions. 
D)  guidelines for frequency of password changes. 
A)  securing the network between client and server. 
B)  guidelines for password lengths. 
C)  password naming conventions. 
D)  guidelines for frequency of password changes. A

Question 4

Forward recovery is faster than restore/rerun because:

Accepted Answer

A)  transactions do not have to be repeated. 
B)  security can be avoided. 
C)  images are mirrored. 
D)  systems are more complete. 
A)  transactions do not have to be repeated. 
B)  security can be avoided. 
C)  images are mirrored. 
D)  systems are more complete.

Question 5

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

Accepted Answer

A) True 
 B)False

Question 6

The process of managing simultaneous operations against a database so that data integrity is maintained is called ________.

Accepted Answer

The answer of The process of managing simultaneous operations against...

Question 7

In order to perform a restore/rerun,the database must be mirrored.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ is a facility by which the DBMS refuses to accept any new transactions.

Accepted Answer

The answer of A(n)________ is a facility by which the...

Question 9

A discrete unit of work that must be processed completely or not at all in a computer system is called a(n)________.

Accepted Answer

The answer of A discrete unit of work that must...

Question 10

________ makes it easier to integrate a new software tool into a development process.

Accepted Answer

Dynamic ex

Question 11

Field-level locks are used quite often.

Accepted Answer

A) True 
 B)False

Question 12

There are two principal types of authorization tables: one for subjects and one for facts.

Accepted Answer

A) True 
 B)False

Question 13

A repository of information about a database that documents data elements of a database is called a:

Accepted Answer

A)  schema. 
B)  subschema. 
C)  view. 
D)  data dictionary. 
A)  schema. 
B)  subschema. 
C)  view. 
D)  data dictionary.

Question 14

The transaction log contains before- and after-images of records that have been modified.

Accepted Answer

A) True 
 B)False

Question 15

Specifications for transactions do not need to be reviewed quickly.

Accepted Answer

A) True 
 B)False

Question 16

A high-level function that is responsible for the overall management of data resources in an organization is called ________.

Accepted Answer

The answer of A high-level function that is responsible for...

Question 17

CASE tool-generated information should be fed into repositories.

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

Accepted Answer

A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  two-phase lock 
A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  two-phase lock

Question 19

The preferred method of fixing an aborted transaction is:

Accepted Answer

A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction. 
A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction.

Question 20

A domain is a way to create a structure that acts like a table.

Accepted Answer

A) True 
 B)False

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

With a one-key encryption standard,both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

Guidelines for server security should include all of the following EXCEPT:

Forward recovery is faster than restore/rerun because:

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

The process of managing simultaneous operations against a database so that data integrity is maintained is called ________.

In order to perform a restore/rerun,the database must be mirrored.

A(n)________ is a facility by which the DBMS refuses to accept any new transactions.

A discrete unit of work that must be processed completely or not at all in a computer system is called a(n)________.

________ makes it easier to integrate a new software tool into a development process.

Field-level locks are used quite often.

There are two principal types of authorization tables: one for subjects and one for facts.

A repository of information about a database that documents data elements of a database is called a:

The transaction log contains before- and after-images of records that have been modified.

Specifications for transactions do not need to be reviewed quickly.

A high-level function that is responsible for the overall management of data resources in an organization is called ________.

CASE tool-generated information should be fed into repositories.

A(n)________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

The preferred method of fixing an aborted transaction is:

A domain is a way to create a structure that acts like a table.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 11: Data and Database Administration

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

With a one-key encryption standard,both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

Guidelines for server security should include all of the following EXCEPT:

Forward recovery is faster than restore/rerun because:

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

The process of managing simultaneous operations against a database so that data integrity is maintained is called ________.

In order to perform a restore/rerun,the database must be mirrored.

A(n)________ is a facility by which the DBMS refuses to accept any new transactions.

A discrete unit of work that must be processed completely or not at all in a computer system is called a(n)________.

________ makes it easier to integrate a new software tool into a development process.

Field-level locks are used quite often.

There are two principal types of authorization tables: one for subjects and one for facts.

A repository of information about a database that documents data elements of a database is called a:

The transaction log contains before- and after-images of records that have been modified.

Specifications for transactions do not need to be reviewed quickly.

A high-level function that is responsible for the overall management of data resources in an organization is called ________.

CASE tool-generated information should be fed into repositories.

A(n)________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

The preferred method of fixing an aborted transaction is:

A domain is a way to create a structure that acts like a table.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters