Exam 1z0-149 topic 1 question 53 discussion

Actual exam question from Oracle's 1z0-149

Question #: 53
Topic #: 1

[All 1z0-149 Questions]

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

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.

Show Suggested Answer

Suggested Answer: CD 🗳️

by Raju_thangavel at March 13, 2023, 7:33 p.m.

Comments

Submit Cancel

jfc1

Highly Voted 1 year, 10 months ago

Selected Answer: 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

upvoted 6 times

...