ANSWER:
C: Dynamic. The dynamic cursor provides the most flexibility and reflect all updates made to the underlying data. Thus, it should only be used when necessary.

Answers in Depth...