Oracle Database: Advanced PL/SQL — Question 9

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

Answer options

• A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
• B. The RETURNING INTO clause and bulk binds may not be used together.
• C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
• D. The RETURNING INTO clause returns column values for rows affected by DML statements.
• E. The RETURNING clause can be used for remote or parallel deletes.

Correct answer: C, D

Explanation

The correct answers are C and D because the RETURNING INTO clause can indeed be used with multiple rows when BULK COLLECT is applied, and it retrieves column values for the rows impacted by DML statements. Options A and B are incorrect as they misrepresent the limitations of the RETURNING INTO clause, and option E is irrelevant to the context of DML operations.