Which three statements best describe a Ref Cursor in Forms Builder?

Which three statements best describe a Ref Cursor in Forms Builder? (Choose three)

Which three statements best describe a Ref Cursor in Forms Builder? (Choose three)

A.
A stored procedure that uses a Ref Cursor can be used only as a query datasource for a data block.

B.
A stored procedure that uses a Ref Cursor can be used only as a DML datasource for a data block.

C.
A stored procedure that uses a Ref Cursor can be used as both a query and a DML datasource for a data block.

D.
A Ref Cursor is ideal for queries that are dependent only on PL/SQL, and not SQL statements.

E.
A Ref Cursor enables you to query multiple tables and encapsulate logic in a PL/SQL subprogram.

F.
A Ref Cursor is used by a stored procedure to return data to a data block.



Leave a Reply 0

Your email address will not be published. Required fields are marked *