DATA AND DATABASE ADMINISTRATION QUIZ

All of these

Data becoming lost or inaccurate

Planned database maintenance activities

The database server

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

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

True

False

False

True

Familiarity with existing data

All of these

Missing data elements

A single definition of the same data entity

All of these

Deadlock

Versioning

Erroneous updates

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

Where the before-images are applied to the database

Where the after-images are applied to the database

Switching to an existing copy of the database

Reprocess transactions

Rollback

Rollforward

Switch to duplicate database

False

True

True

False