Question

Difference between pessimistic and optimistic concurrency control in dbms

Answer 1

Explanation:

difference between “Optimistic” and “Pessimistic” locking? - In pessimistic locking, when a user opens a data to update it, a lock is granted. ... - In optimistic locking, a data is opened for updating by multiple users. A lock is granted only during the update transaction and not for the entire session.