Which type of lock still allows other transactions to have read-only access to the locked resource?
A)Exclusive lock
B)Shared lock
C)Explicit lock
D)Implicit lock

Question

Quizplus · Accepted Answer

A shared lock allows multiple transactions to have read-only access to the locked resource at the same time, while still blocking any transactions that attempt to modify or write to it. This is useful in scenarios where multiple transactions need to access the same resource simultaneously but do not need to make any changes to it. An exclusive lock, on the other hand, blocks all other transactions from accessing the locked resource, even for read-only purposes.

Which Type of Lock Still Allows Other Transactions to Have