DATA AND DATABASE ADMINISTRATION QUIZ

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

Database design

Metadata

Data modeling

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

True

False

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

Incorrect data is easy to detect.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Reprocess transactions

Rollforward

Switch to duplicate database

Rollback

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Performance analysis and tuning is which of the following?

Undertaken as an ongoing part of the backup of a database

Undertaken one time at the time of the implementation of a new application

Undertaken one time at the time of a DBMS installation

Undertaken as an ongoing part of managing a database

TRUE ANSWER : ?
YOUR ANSWER : ?

Backward recovery is which of the following?

Switching to an existing copy of the database

Where the after-images are applied to the database

Where the before-images are applied to the database

Where the after-images and before-images are applied to the database

TRUE ANSWER : ?
YOUR ANSWER : ?

The transaction log includes which of the following?

The essential data of the record

The before-image of a record

The before and after-image of a record

The after-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?