Oracle Database Advanced PL SQL 12c 1z0 148

Question : 18 of 54

Marks: +1, -0

A PRODUCTS table exists with a PROD_ID column.
Examine this PL/SQL block:

Which statement is true?

It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (v_cur); is added before the FETCH statement.
It executes successfully.
It executes successfully only if v_ref_cur := DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);

Go to Question:

Prev Question

Next Question