DATA AND DATABASE ADMINISTRATION QUIZ

Data becoming lost or inaccurate

All of these

Planned database maintenance activities

The database server

Tune database performance

Establish backup and recovery procedures

Resolve data ownership issues

Protect the security of the database

Versioning

Deadlock

Erroneous updates

All of these

Undertaken as an ongoing part of managing 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 the backup of a database

False

True

Reprocess transactions

Rollforward

Rollback

Switch to duplicate database

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

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

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

True

False

All of these

Database design

Data modeling

Metadata

Reprocess transactions

Rollforward

Switch to duplicate database

Rollback