Register now or log in to join your professional community.
Shared(S):Used for read operations that do not change or update data, such as a SELECT statement.
Update(U):Used on resources that can be updated. Prevents a common form of deadlock that occurs when multiple sessions are reading, locking, and potentially updating resources later.
Exclusive(X):Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same time.
