DATA AND DATABASE ADMINISTRATION QUIZ

A data warehouse administrator is concerned with which of the following?

The typical roles of a database administrator and redesigning existing applications

The time to make a decision but not the typical roles of a database administrator

The typical roles of a data administrator and redesigning existing applications

The time to make a decision and the typical roles of a database administrator

TRUE ANSWER : ?
YOUR ANSWER : ?

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

All of these

Database design

Data modeling

Metadata

TRUE ANSWER : ?
YOUR ANSWER : ?

The greatest threat to business security is often internal rather than external.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The transaction log includes which of the following?

The after-image of a record

The before and after-image of a record

The essential data of the record

The before-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?

A traditional data administrator performs which of the following roles?

Tune database performance

Protect the security of the database

Establish backup and recovery procedures

Resolve data ownership issues

TRUE ANSWER : ?
YOUR ANSWER : ?

Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A shared lock allows which of the following types of transactions to occur?

Insert

Read

Delete

Update

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Switch to duplicate database

Rollforward

Rollback

Reprocess transactions

TRUE ANSWER : ?
YOUR ANSWER : ?

A disaster recovery plan does not need to include the shipment of database backups to other sites.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Failure to control confidentiality may lead to loss of competitiveness.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑