what is the type of lock that prevents all other types of lock ?
-
Inclusive
-
Exclusive
-
Read
-
Write
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.