How can query locks be configured? Tell about types of locks (pessimistic, optimistic, advisory locks).