Multiple choice technology databases

what is the type of lock that prevents all other types of lock ?

  1. Inclusive

  2. Exclusive

  3. Read

  4. Write

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An exclusive lock is the most restrictive lock type that prevents all other locks from being acquired on the same resource. When a transaction holds an exclusive lock, no other transaction can obtain any type of lock (shared, read, or write) on that resource, ensuring complete isolation during write operations.