Cursor Types and Scope: Self-Check: Answers
Objective: Explain the correct choices.
Compare these explanations with your own choices. Each question has one best answer.
1. Which declaration requests one read-only forward pass?
A. LOCAL FAST_FORWARD
FAST_FORWARD specifies forward-only, read-only behavior. LOCAL makes the intended scope explicit.
2. Where is a GLOBAL cursor name visible?
B. Batches and procedures on the same connection
GLOBAL is connection-wide. It does not make the cursor available to other users' sessions.
3. Does READ_ONLY mean forward-only?
B. No, updateability and scrolling are separate options
For example, a STATIC SCROLL READ_ONLY cursor can navigate backward without permitting positioned updates.
4. What does a cursor variable hold?
B. A reference to a cursor
Several references can point to one cursor. Removing one reference need not remove the cursor itself.
5. Which resource claim is reliable?
C. Resource use depends on workload and implementation
Choose the required behavior and measure the query and per-row work. Fixed rankings are misleading.