FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Transaction Management and Concurrency Control

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) shared
B) exclusive
C) binary
D) two-phase

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

In a page-level lock,the DBMS will lock an entire diskpage.

A) True
B) False

Correct Answer

verified

True

Question 3

True/False

Review LaterAdd Note

The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.

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

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

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

The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data-thus violating the isolation property of transactions.

Most multiuser automatically initiate and enforce locking procedures,where all locking information is managed by the lock manager.

-level locks are less restrictive than database-level locks,but they create traffic jams when many transactions are waiting to access the same table.

The scheduler's main job is to create a(n)of a transaction's operation,in which the interleaved executions of transactions yield the same results as if the transactions were executed in serial order.

In the wait/die scheme,:

are required to prevent another transaction from reading inconsistent data.

Serializability means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

To determine the appropriate order of the operations,the scheduler bases its actions on concurrency control algorithms,such as or time stamping methods.

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

A lock guarantees the open use of a data item to multiple transactions.

ANSI defines four events that signal the end of a transaction.Of the following events,which is defined by ANSI as being equivalent to a COMMIT?

In the optimistic approach,during the phase,changes are permanently applied to the database. a.read b.validation c.write d.shared

What is a rule that applies to the two-phase locking protocol?

A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.