Cursor Types and Scope: 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 declaration requests one read-only forward pass? A. LOCAL FAST_FORWARD B. GLOBAL SCROLL C. LOCAL KEYSET SCROLL_LOCKS

2. Where is a GLOBAL cursor name visible? A. Every SQL Server connection B. Batches and procedures on the same connection C. Only inside its declaring procedure

3. Does READ_ONLY mean forward-only? A. Yes, it allows only NEXT B. No, updateability and scrolling are separate options C. Yes, it allows NEXT and LAST

4. What does a cursor variable hold? A. A copy of every result row B. A reference to a cursor C. A database-wide global variable

5. Which resource claim is reliable? A. STATIC always uses the least memory B. DYNAMIC always uses the most memory C. Resource use depends on workload and implementation

View answers and explanations