Sql Interview Question #6: What are pessimistic and optimistic locks? This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged locks optimistic pessimistic server sql on 10/18/2014 by Blog Admin. Sql Interview Question What are pessimistic and optimistic locks?