Exam 12: Data and Database Administration

What are the four basic facilities that a database management system should provide for backup and recovery?

A device to measure or detect fingerprints or signatures is called a(n) ________ device.

Allocating 10 percent over suggested installation space is sufficient for a DBMS.

A key component of the Sarbanes-Oxley Act was enacted to ensure the integrity of IT infrastructure in use within an organization.

Open-source software always comes with complete documentation.

Database applications are not very disk intensive.

The record log is a record of the essential data for each transaction that has been processed against the database.

What threats to data security must be addressed in a comprehensive data security plan?

While views promote security by restricting user access to data, they are not adequate security measures because:

What are the most important security features for data management software?

A domain is a way to create a structure that acts like a table.

With ________, the database itself is lost, destroyed, or cannot be read.

Backward recovery starts with an earlier copy of the database.

Any data that are retrieved by a user for updating must be locked until the update is completed or aborted.

________ is used to undo unwanted database changes.

The extent of the database resource that is included with each lock is called the level of:

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

The granularity of locking is not a critical decision in database design.

An optimistic approach to concurrency control is called:

A shared lock allows other transactions to read but not update records in use.