ANSWER:
D: Optimistic locking can apply both shared and exclusive locks. A cursor with optimistic locking will obtain shared locks at creation. Exclusive locks will be requested when an update occurs.

Answers in Depth...