Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 154 discussion

Actual exam question from Oracle's 1z0-071

Question #: 154
Topic #: 1

[All 1z0-071 Questions]

Which two are true about the MERGE statement? (Choose two.)

A. The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.
B. The WHEN NOT MATCHED clause can be used to specify the updates to be performed.
C. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.
D. The WHEN WATCHED clause can be used to specify the inserts to be performed.
E. The WHEN WATCHED clause can be used to specify the updates to be performed.

Show Suggested Answer

Suggested Answer: CE 🗳️

by jfc1 at March 3, 2023, 2:16 p.m.

Comments

Submit Cancel

lucemqy

7 months, 2 weeks ago

Selected Answer: CE

CE are correct

upvoted 1 times

...

uselessscript

7 months, 3 weeks ago

Just finished the exam, the other two answers are supposed to say matched, not watched.

upvoted 2 times

...

Rik92

1 year, 2 months ago

Selected Answer: CE

CE are correct

upvoted 1 times

...

Darnun

1 year, 3 months ago

Selected Answer: CE

CE are correct

upvoted 1 times

...

Thorc

1 year, 3 months ago

Selected Answer: CE

CE are correct

upvoted 1 times

...

jfc1

1 year, 4 months ago

Selected Answer: CE

I suggest C,E https://docs.oracle.com/database/121/SQLRF/statements_9017.htm#SQLRF01606

upvoted 3 times

...