ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-149 All Questions

View all questions & answers for the 1z0-149 exam
Go to Exam

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 Hide Answer
Suggested Answer: CD 🗳️
by Raju_thangavel at March 13, 2023, 7:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jfc1
Highly Voted 1 year, 6 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
...
c1a0049
Most Recent 5 months ago
Selected Answer: CD
C and D (verified via Oracle documentation)
upvoted 1 times
...
2oracleexam
1 year, 1 month ago
Selected Answer: CD
C and D
upvoted 1 times
...
thranduyl
1 year, 1 month ago
C, D. Tested every day!
upvoted 1 times
...
abdullah_barham
1 year, 10 months ago
Selected Answer: CD
The answer is C and D
upvoted 1 times
...
Raju_thangavel
1 year, 10 months ago
Answer is C & D
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago