Exclusive locks When a statement modifies data, its transaction holds an exclusive lock on data that prevents other transactions from accessing the data. Exclusive locksdefinition Shared locksdefinition

This lock remains in place until the transaction holding the lock issues a commit or rollback. Table-level locking lowers concurrency in a multi-user system.