How are locking mechanisms (Pessimistic/Optimistic) related to database transaction isolation levels? How are locking mechanisms (Pessimistic/Optimistic) related to database transaction isolation levels? database database