Lock Grants
Whether a lock can be granted on a resource depends on whether another transaction holds a lock and what lock mode is in place on the resource. For example, if a transaction holds an exclusive lock on a resource, and a second transaction requests an exclusive lock, it cannot be granted and the second request will (by default) wait.