can anyone describe the risk involved with using explicit lo

can anyone describe the risk involved with using explicit locks?

Solution

Answer:

By using explicit locking , the remaining transactions have to wait for the first to finish. There are two modes to lock explicitly :

1.Exclusive Mode : - Here the other transaction cannot access the table , this will cause loss of information.

2. Share Mode : - Here the transactions can read the table , but cannot update it. Hence in both the mode risks are at high peak. In both the cases we are at risk to loss the sensitive information.