Multiple choice technology databases

Is DECLARE CURSOR Executable?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DECLARE CURSOR is a declarative SQL statement, not an executable statement. It defines the cursor's characteristics and the query it will execute, but doesn't actually perform any action when encountered. You must declare a cursor before you can OPEN, FETCH from, or CLOSE it. The declaration happens at compile/prepare time, not runtime.

Keep practicing — related questions