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.