Record Locking In Database Record Locking In Database: Record Locking mechanism is the most common method to implement the concurrency control in DBMS. Locking means record or set of records…
Exclusive Locks In Database
Exclusive Locks In Database: Exclusive locks are also called Write Locks. In case of exclusive locking, other transactions cannot be read or update the locked records. Exclusive locks is applied in situations when you want to change or update records during this time. Other transaction cannot apply any type of locks on exclusively locked records.
Noted that the locks are applied for short time only as other users are restricted for certain operations during this time. Record locking mostly occurs when two or more transaction of different types functioning at the same time for two different purposes. It mostly damages the database.