Julia has an exclusive lock on the savings account and Bill is trying to perform an action requesting a shared lock on the same data:
A) Bill's transaction is granted permission to perform the desired action
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

Question

Quizplus · Accepted Answer

In this scenario, Julia already has an exclusive lock on the savings account, which means she has full control over the account and no other transaction can access it until her lock is released. Bill is requesting a shared lock, which means he wants to read the data but not modify it. However, since Julia already has an exclusive lock on the account, Bill must wait until Julia's lock is released before he can perform any action on the account. Therefore, choice B is the best option.

Julia Has an Exclusive Lock on the Savings Account and Bill