Multiple choice technology databases

Which of the following is not a feature of a cursor FOR loop?

  1. Record type declaration.

  2. Opening and parsing of SQL statements.

  3. Fetches records from cursor.

  4. Requires exit condition to be defined.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A cursor FOR loop automatically handles: declaring a record type variable, opening the cursor, parsing SQL, fetching records, and closing the cursor when done. The only thing it does NOT require is an explicit exit condition - the loop terminates automatically when all rows are fetched. This makes Option D the correct answer.

Keep practicing — related questions