Which two are true about the MERGE statement? (Choose two.)
Which two are true about the MERGE statement? (Choose two.)
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.
I suggest C,E https://docs.oracle.com/database/121/SQLRF/statements_9017.htm#SQLRF01606
CE are correct
Just finished the exam, the other two answers are supposed to say matched, not watched.
CE are correct
CE are correct
CE are correct