Answer 13

Correct answer: b

Explanation:

When each FETCH returns a row, %ROWCOUNT is incremented by one. The next fetch statement is issued but it will not return a row. Thus, the current value of the %ROWCOUNT attribute is seven, as the query has returned seven rows.

%ROWCOUNT attribute always returns a NUMBER value, so choice D is incorrect.

If a query has returned some rows, then the value of %ROWCOUNT attribute cannot be 0. Thus, choice A is incorrect.