Intent Shared Lock

Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions?
CHOICE1:
A Read Lock that prevents writes
CHOICE2:
A Read Lock that prevents other reads
CHOICE3:
A Read Lock that prevents more restrictive Locks
CHOICE4:
A Read Lock that allows other reads
CHOICE5:
A Read Lock that allows writes (Dirty Reads)

Questions by karpagap

Showing Answers 1 - 9 of 9 Answers

hmounir

  • May 3rd, 2010
 

A Read Lock that allows other reads 
Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control.
No other transactions can modify the data while shared (S) locks exist on the resource. Shared (S) locks on a resource are released as soon as the read operation completes.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions