Exam 10: Transaction Management and Concurrency Control

To ensure consistency of the database,every transaction must begin with the database in an unstable state.

Atomicity indicates the permanence of the database's consistent state.

Explain the transaction log.What is its function?

The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.

____________________ can take place at any of the following levels: database,table,page,row,or field.

What are the three basic techniques to control deadlocks?

One of the three most common data integrity and consistency problems is ____.

The ____ manager is responsible for assigning and policing the locks used by the transactions.

A transaction is a ____ unit of work that must be either entirely completed or aborted.

The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.