Exam 9: Managing Multiuser Databases

Both rollforward and rollback require the use of a log of transaction results.

Distinguish between statement-level consistency and transaction-level consistency.

The situation that occurs when one user's changes to the database are lost by a second user's changes to the database is known as the ________.

A static cursor processes a snapshot of the relation that was taken when the cursor was opened.

A transaction is sometimes called atomic because it is performed as a unit.

Which type of lock prevents all types of access to the locked resource?

Explain the concept of an atomic transaction.

The size of a lock is referred to as the lock granularity.

Changes in the database structure usually involve only one application.

When a transaction reads a row that has been changed,but the change has not been committed,this is known as a ________.

Rollforward and reprocessing are two different names for the same technique.

Once processing rights have been defined,they may be implemented at any of these levels except ________.

A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.

Explain the purpose of transaction logs and checkpoints.

The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.

Repeatable Read isolation is the most restrictive level of isolation.

Processing responsibilities should be documented and encoded into manual procedures.

Transaction level consistency means that all rows impacted by any actions in a transaction are protected from change during the entire transaction.

The situation that occurs when two users are each waiting for a resource that the other person has locked is known as a(n)________.

The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.