module 8 part #4

Question 1

holds the output of a SQL statement that may return two or more rows

Answer 1

Explicit cursor

Question 2

_______ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.

a. %ROWCOUNT
b. %NOTFOUND
c. %FOUND
d. %ISOPEN

Answer 2

c. %FOUND