DATA AND DATABASE ADMINISTRATION QUIZ

Switch to duplicate database

Rollforward

Rollback

Reprocess transactions

The typical roles of a data administrator and redesigning existing applications

The typical roles of a database administrator and redesigning existing applications

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

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

A single definition of the same data entity

Familiarity with existing data

Missing data elements

All of these

False

True

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 free or nearly free database software whose source code is publicly available

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

False

True

Resolve data ownership issues

Tune database performance

Establish backup and recovery procedures

Protect the security of the database

False

True

True

False

Where the before-images are applied to the database

Where the after-images are applied to the database

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

Switching to an existing copy of the database