ANSWER:
A: A forward-scrolling, read-only cursor. This cursor will use the minimum resources, followed by the static optimistic cursor. The dynamic, pessimistic cursor will be slowest.

Answers in Depth...