Discuss three possible problems that can occur because of concurrent processing that are addressed by resource locking.
If concurrent transactions with interleaving operations are allowed in an uncontrolled manner, some unexpected, undesirable result might take place. The solution explains three typical examples:
1) The lost Update Problem
2) The dirty read problem
3) Phantom Reads