DATA AND DATABASE ADMINISTRATION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A shared lock allows which of the following types of transactions to occur?

Read

Update

Delete

Insert

TRUE ANSWER : ?
YOUR ANSWER : ?

A transaction log shows before and after images of records that have been modified by transactions.

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

Undertaken one time at the time of a DBMS installation

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

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

Rollback

Switch to duplicate database

Rollforward

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Locking may cause which of the following problems?

All of these

Versioning

Deadlock

Erroneous updates

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Rollback

Reprocess transactions

Switch to duplicate database

Rollforward

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?