DATA AND DATABASE ADMINISTRATION QUIZ

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

Read

Update

Insert

Delete

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 transaction log shows before and after images of records that have been modified by transactions.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

The typical roles of a database administrator and redesigning existing applications

The typical roles of a data administrator and redesigning existing applications

TRUE ANSWER : ?
YOUR ANSWER : ?

Locking may cause which of the following problems?

Erroneous updates

Deadlock

All of these

Versioning

TRUE ANSWER : ?
YOUR ANSWER : ?

Mirrored databases are almost always provided in high-availability systems.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Rollback

Reprocess transactions

Rollforward

Switch to duplicate database

TRUE ANSWER : ?
YOUR ANSWER : ?

The transaction log includes which of the following?

The essential data of the record

The after-image of a record

The before and after-image of a record

The before-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?

Databases are not the property of a single function or individual within the organization.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?