Which of the following is true about a shared lock?
A) It is more restrictive than an implicit lock.
B) It allows only two transactions to update a record simultaneously.
C) It locks the item from all access.
D) It allows reads to the locked item.
E) It must use a two-phase locking scheme.

Question

Quizplus · Accepted Answer

A shared lock allows multiple transactions to read the locked item simultaneously while preventing any updates or modifications. This means that it is less restrictive than an exclusive lock and still allows some level of concurrency. A shared lock does not completely lock the item from all access, as reads are still permitted. Also, it may or may not use a two-phase locking scheme, depending on the implementation.

Which of the Following Is True About a Shared Lock