A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock.
A) shared
B) exclusive
C) binary
D) two-phase

Question

A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock.
A) shared 
B) exclusive
C) binary
D) two-phase

Quizplus · Accepted Answer

A shared lock exists when concurrent transactions are granted read access on the basis of a common lock. This means that multiple transactions can hold a shared lock on a resource simultaneously, allowing them to read the resource but not modify it. This ensures that transactions can access the resource without interfering with each other, while still maintaining data consistency.

A(n) _____ Lock Exists When Concurrent Transactions Are Granted Read