Multiple Choice
What is a rule that applies to the two-phase locking protocol?
A) Two transactions cannot have conflicting locks.
B) No unlock operation can precede a lock operation in a different transaction.
C) No data is affected until all locks are released.
D) No data is affected until the transaction is in its locked position.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: A field-level lock allows concurrent transactions to
Q11: _-level locks are less restrictive than database-level
Q16: are required to prevent another transaction from
Q19: ANSI defines four events that signal the
Q23: ANSI defines four events that signal the
Q25: The transaction recovery write-ahead-log protocol ensures that
Q30: The phenomenon of uncommitted data occurs when
Q40: If T1 has not unlocked data item
Q44: One of the three most common data
Q57: Durability requires that all portions of the