Exam 10: Transaction Management and Concurrency Control

A(n)____ specifically reserves access to the transaction that locked the object.

____ requires that all operations of a transaction be completed.

A field-level lock allows concurrent transactions to access the same row,as long as they require the use of different fields within that row.

A(n)____ lock exists when concurrent transactions are granted read access on the basis of a common lock.

The implicit beginning of a transaction is ____.

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

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

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

A diskpage,or page,is the equivalent of a ____.

A(n)____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.