Julia has a shared 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

Shared locks allow multiple transactions to read a database resource simultaneously, so Bill's transaction can proceed with a shared lock even while Julia has one.

Julia Has a Shared Lock on the Savings Account and Bill