Examice

Exam 1z0-149 All QuestionsBrowse all questions from this exam

Go to Exam

Question 45

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

When using the RETURNING INTO clause, the data returned can be only single column or expression.

The RETURNING INTO clause and bulk binds may not be used together.

The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

The RETURNING INTO clause returns column values for rows affected by DML statements.

The RETURNING clause can be used for remote or parallel deletes.

Correct Answer: C, D

The RETURNING INTO clause can be used with DML that affects multiple rows if the BULK COLLECT clause is used. This allows capturing the results of an operation affecting multiple rows into collections. The RETURNING INTO clause returns column values for rows affected by DML statements, enabling retrieval of values of specific columns from the affected rows without executing another select query.

Discussion

jfc1Options: CD

C,D is correct E is incorrect https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/RETURNING-INTO-clause.html#GUID-38F735B9-1100-45AF-AE71-18FB74A899BE

Raju_thangavelOptions: CD

Answer is C & D

2oracleexamOptions: CD

C and D

thranduylOptions: CD

C, D. Tested every day!

abdullah_barhamOptions: CD

The answer is C and D