Oracle Database SQL — Question 97

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

Answer options

• 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.

Correct answer: C, E

Explanation

The correct answers are C and E. The WHEN NOT MATCHED clause is indeed used for specifying inserts, while the WHEN WATCHED clause does not exist; thus options A, B, and D are incorrect. In a typical MERGE operation, updates can be specified under the appropriate conditions, making E a valid statement as well.