Oracle Database Advanced PL SQL 12c 1z0 148

Question : 45 of 54

Marks: +1, -0

Which two statements are true about conversion from DBMS_SQL to native dynamic SQL? (Choose two.)

The DBMS_SQL.TO_REFCURSOR function should be used when the number of bind variables is known at compile time, but not the number of items to be selected.
The DBMS_SQL.TO_REFCURSOR function converts a SQL cursor number to a weakly typed cursor variable only after it has been opened, parsed, and executed via DBMS_SQL.
DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable.
The DBMS_SQL.TO_REFCURSOR function allows a query result to be returned implicitly from a non PL/SQL environment to a stored PL/SQL program.
The DBMS_SQL.IS_OPEN function is used to verify that a SQL cursor number is open after it has been converted to a REF CURSOR.

Go to Question:

Prev Question

Next Question