What is an exclusive lock?

An exclusive lock is a type of lock that prevents other transactions from accessing a resource while it is being modified. When an exclusive lock is held on a database object, no other transaction can acquire any type of lock (exclusive or shared) on that object until the exclusive lock is released. This mechanism ensures data integrity and consistency during operations that require exclusive access. Exclusive locks are typically used during write operations to prevent conflicts.