The transaction log includes which of the following?

Information repositories are replacing data dictionaries in many organizations.

To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.

Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

Which of the following could cause data to be unavailable?

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

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

Failure to control confidentiality may lead to loss of competitiveness.

Authorization tables contain highly sensitive data and should be protected by stringent security rules.

A disaster recovery plan does not need to include the shipment of database backups to other sites.

With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

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

Queries that do full table scans should be avoided.

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

Data modeling and database design are key responsibilities of data and data base administration.