Three types of locks:

READ ONLY:

This prevents any updates on the table. 

SCROLL LOCK:

This allows you to make changes to the table.

OPTIMISTIC:

• This checks if any change in the table record since the row fetched before updating. 
• If there is no change, the cursor can update.