- Exclusive lock (X) This lock type, when imposed, will ensure that a page or row will be reserved exclusively for the transaction that imposed the exclusive lock, as long as the transaction holds the lock. (imposed by DML Statments)
DBMS products use a locking mechanism to control access and modifications while ensuring data integrity.
- SQL Table hints