DATA AND DATABASE ADMINISTRATION QUIZ

Which of the following is the preferred way to recover a database after a system failure?

Reprocess transactions

Rollforward

Switch to duplicate database

Rollback

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 traditional data administrator performs which of the following roles?

Protect the security of the database

Tune database performance

Establish backup and recovery procedures

Resolve data ownership issues

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

The transaction log includes which of the following?

The before-image of a record

The essential data of the record

The before and after-image of a record

The after-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is true concerning open-source DBMS?

Is free or nearly free database software whose source code is publicly available

Is free or nearly free database software whose source code is not publicly available

Is not competitive against PC-oriented packages and is fully SQL compliant

Is competitive against PC-oriented packages and is not fully SQL compliant

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following could cause data to be unavailable?

Data becoming lost or inaccurate

All of these

The database server

Planned database maintenance activities

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?