DATA AND DATABASE ADMINISTRATION QUIZ

The transaction log includes which of the following?

The after-image of a record

The essential data of the record

The before-image of a record

The before and after-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?

Locking may cause which of the following problems?

Deadlock

Versioning

All of these

Erroneous updates

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 : ?

With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The typical roles of a database administrator and redesigning existing applications

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

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

TRUE ANSWER : ?
YOUR ANSWER : ?

A transaction log shows before and after images of records that have been modified by transactions.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Authorization tables contain highly sensitive data and should be protected by stringent security rules.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Failure to control confidentiality may lead to loss of competitiveness.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Data modeling and database design are key responsibilities of data and data base administration.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑