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
Q42: A lock allows concurrent transactions to access
Q44: A(n) _ specifically reserves access to the
Q45: The _ occurs when two concurrent transactions,
Q48: A(n) _ condition occurs when two or
Q49: A lock locks the entire diskpage.
A)transaction-level
B)table-level
C)page-level
D)row-level
Q52: A lock locks the entire table preventing
Q57: The objective of _ control is to
Q58: The scheduler's main job is to create
Q59: If a(n) _ is issued before the
Q60: The _ approach to scheduling concurrent transactions
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents