SQL Server 2025 Cursors: Final Self-Check

Objective: Review the module concepts.

Choose one answer per question, then compare your choices with the explanations. This is a self-check; choices are not submitted or saved.

1. Which operation returns the first row after OPEN? A. DECLARE B. FETCH NEXT C. CLOSE

2. Which option supports ABSOLUTE navigation? A. LOCAL FAST_FORWARD B. LOCAL SCROLL STATIC READ_ONLY C. LOCAL SCROLL DYNAMIC READ_ONLY

3. What should you try first for updating every matching row? A. One set-based UPDATE B. One cursor per row C. A global cursor

4. What does CLOSE retain? A. An open result that can still be fetched B. The cursor structures needed for reopening C. A committed transaction

5. When are cursor structures freed by DEALLOCATE? A. Whenever any reference is removed B. When the last reference is removed C. Only when SQL Server restarts

6. When should @@FETCH_STATUS be checked? A. Before OPEN B. Immediately after the FETCH being evaluated C. Only once when declaring the cursor

7. What is fixed in a fully populated keyset? A. All column values forever B. Key membership and ordering C. Every concurrent transaction

View answers and explanations