THE DATABASE DEVELOPMENT PROCESS QUIZ

A traditional data administrator performs which of the following roles?

Resolve data ownership issues

Protect the security of the database

Tune database performance

Establish backup and recovery procedures

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Rollback

Reprocess transactions

Rollforward

Switch to duplicate database

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Metadata

All of these

Data modeling

Database design

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

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

The transaction log includes which of the following?

The before and after-image of a record

The essential data of the record

The before-image of a record

The after-image of a record

TRUE ANSWER : ?
YOUR ANSWER : ?

Poor data administration can lead to which of the following?

Missing data elements

Familiarity with existing data

A single definition of the same data entity

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑