Question 1

An audit trail of transactions and database changes is kept by a journalizing facility.

Accepted Answer

A) True 
 B)False

Question 2

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.

Question 3

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

Accepted Answer

A) True 
 B)False

Question 4

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

Accepted Answer

A) True 
 B)False

Question 5

The coding or scrambling of data so that humans cannot read them is called:

Accepted Answer

A)  demarcation. 
B)  hiding. 
C)  encoding. 
D)  encryption. 
A)  demarcation. 
B)  hiding. 
C)  encoding. 
D)  encryption.

Question 6

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

Accepted Answer

A) True 
 B)False

Question 7

A typical cause of database destruction is a disk crash.

Accepted Answer

A) True 
 B)False

Question 8

CASE tool-generated information should be fed into repositories.

Accepted Answer

A) True 
 B)False

Question 9

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

Accepted Answer

A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger 
A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger

Question 10

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 11

An organization should have one data warehouse administrator for every:

Accepted Answer

A)  100 users. 
B)  100 gigabytes of data in the enterprise data warehouse. 
C)  department. 
D)  processor. 
A)  100 users. 
B)  100 gigabytes of data in the enterprise data warehouse. 
C)  department. 
D)  processor.

Question 12

The Information Resource Lexicon System (IRLS) is a computer software tool used to manage and control access to the information repository.

Accepted Answer

A) True 
 B)False

Question 13

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 14

What are some of the core roles of a database administrator?

Accepted Answer

Some of the core roles of a database adm

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is NOT a component of a repository system architecture?

Accepted Answer

A)  An informational model 
B)  The repository engine 
C)  A data transformation process 
D)  The repository database 
A)  An informational model 
B)  The repository engine 
C)  A data transformation process 
D)  The repository database

Question 17

Research shows that if an online customer does not get the service he or she expects within a few ________, the customer will switch to a competitor.

Accepted Answer

A)  seconds 
B)  minutes 
C)  hours 
D)  days 
A)  seconds 
B)  minutes 
C)  hours 
D)  days

Question 18

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Accepted Answer

A) True 
 B)False

Question 19

Sarbanes-Oxley Act was enacted to ensure the integrity of:

Accepted Answer

A)  SQL. 
B)  public companies' financial statements. 
C)  private companies shareholders meetings. 
D)  Entity-Relationship Diagrams. 
A)  SQL. 
B)  public companies' financial statements. 
C)  private companies shareholders meetings. 
D)  Entity-Relationship Diagrams.

Question 20

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

Accepted Answer

A)  logging 
B)  concurrency control 
C)  transaction authorization 
D)  multiple management 
A)  logging 
B)  concurrency control 
C)  transaction authorization 
D)  multiple management

An audit trail of transactions and database changes is kept by a journalizing facility.

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

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

The coding or scrambling of data so that humans cannot read them is called:

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

A typical cause of database destruction is a disk crash.

CASE tool-generated information should be fed into repositories.

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

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

An organization should have one data warehouse administrator for every:

The Information Resource Lexicon System (IRLS) is a computer software tool used to manage and control access to the information repository.

Forward recovery is faster than restore/rerun because:

What are some of the core roles of a database administrator?

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

Which of the following is NOT a component of a repository system architecture?

Research shows that if an online customer does not get the service he or she expects within a few ________, the customer will switch to a competitor.

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Sarbanes-Oxley Act was enacted to ensure the integrity of:

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 12: Data and Database Administration

An audit trail of transactions and database changes is kept by a journalizing facility.

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

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

The coding or scrambling of data so that humans cannot read them is called:

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.

A typical cause of database destruction is a disk crash.

CASE tool-generated information should be fed into repositories.

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

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

An organization should have one data warehouse administrator for every:

The Information Resource Lexicon System (IRLS) is a computer software tool used to manage and control access to the information repository.

Forward recovery is faster than restore/rerun because:

What are some of the core roles of a database administrator?

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

Which of the following is NOT a component of a repository system architecture?

Research shows that if an online customer does not get the service he or she expects within a few ________, the customer will switch to a competitor.

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Sarbanes-Oxley Act was enacted to ensure the integrity of:

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters