Multiple Choice
What rule applies to the two-phase locking protocol?
A) Two transactions cannot have conflicting lock.
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
Q31: The _ manager is responsible for assigning
Q32: A(n) _ lock exists when concurrent transactions
Q33: The _ approach to scheduling concurrent transactions
Q34: The serializable isolation level is the least
Q35: The DBMS uses the information stored in
Q37: Transaction is a _ unit of work
Q38: Although the DBMS is designed to recover
Q39: In the wait/die scheme, the:<br>A) older transaction
Q40: If T1 has not unlocked data item
Q41: A growing phase in a two-phase lock