TABLE 2: Locking Options For Each Cursor Type
  Locking Options
Cursor Type Read-Only Pessimistic Optimistic BatchOptimistic
Client - Static Yes N/A Yes Yes
Server - Static Yes N/A N/A N/A
Dynamic Yes Yes Yes N/A
Keyset Yes Yes Yes N/A
Forward-only Yes YesYes N/A