Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 151

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

    Correct Answer: C, E

    The MERGE statement is used to combine the insertion, updating, and deletion of rows in a single statement. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed. The WHEN matched clause can be used to specify the updates to be performed, but since there is no properly matching clause for updates in the options, option E which mentions 'WHEN WATCHED clause' likely contains a typographical error and intends to refer to the matched condition.

Discussion
jfc1Options: CE

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

lucemqyOptions: CE

CE are correct

uselessscriptOptions: BC

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

Rik92Options: CE

CE are correct

DarnunOptions: CE

CE are correct

ThorcOptions: CE

CE are correct