The following table shows the compatibility between lock types. "Yes" means that the lock types are compatible, while "No" means that they are incompatible. This table shows the compatibility between shared, update, and exclusive lock types. Lock Type Shared Update Exclusive Shared Yes Yes No Update Yes No No Exclusive No No No