Oracle
1Z0-141 · Question #19
Which three statements best describe a Ref Cursor in Forms Builder? (Choose three.)
The correct answer is A. A stored procedure that uses a Ref Cursor can be used only as a query datasource for a data E. A Ref Cursor enables you to query multiple tables and encapsulate logic in a PL/SQL F. A Ref Cursor is used by a stored procedure to return data to a data block. See the full explanation below for the reasoning.
Question
Which three statements best describe a Ref Cursor in Forms Builder? (Choose three.)
Options
- AA stored procedure that uses a Ref Cursor can be used only as a query datasource for a data
- BA stored procedure that uses a Ref Cursor can be used only as a DML datasource for a data
- CA stored procedure that uses a Ref Cursor can be used as both a query and a DML
- DA Ref Cursor is ideal for queries that are dependent only on PL/SQL, and not SQL
- EA Ref Cursor enables you to query multiple tables and encapsulate logic in a PL/SQL
- FA Ref Cursor is used by a stored procedure to return data to a data block.
How the community answered
(43 responses)- A81% (35)
- B12% (5)
- C2% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.