What are the differences between lock types which are: share mode share update mode exclusive mode

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.