Multiple Choice
Julia has a shared lock on the savings account and Bill is trying to perform an action requesting an exclusive lock on the same data:
A) Bill's transaction is granted permission to perform the desired action and Julia's transaction must now wait
B) Bill's transaction must wait until Julia's lock is released
C) Bill's transaction must wait until Julia has read the savings account value
D) None of the above
Correct Answer:
Verified
Correct Answer:
Verified
Q2: For each transaction,the _ statement can be
Q3: Julia has a lock on the savings
Q4: When an update to the database takes
Q5: The optimistic concurrency control approach may delay
Q6: A(n)_ is an inconsistent retrieval problem which
Q8: Which of the following will cause a
Q9: Some transactions have tentative actions that can
Q10: Which of the following is an example
Q11: Consider a transaction that updates each of
Q12: Depending on the DBMS,checkpoints:<br>A) Are performed when