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.

Record Locking In Database

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…

Continue Reading Record Locking In Database