engineering recuitment RPSC Programmer Mock Test 2024 DBMS Concurrency Control Two Phase Locking Protocol
The advantage of optimistic locking is
1
The lock is obtained only after the transaction has processed
2
The lock is obtained only before the transaction has processed
3
The lock never needs to be obtained
4
The lock transactions are best suited with a lot of activity