Oracle Database SQL — Question 205

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

Answer options

• A. It can use subqueries to produce source rows.
• B. It can update the same row of the target table multiple times.
• C. It can update, insert, or delete rows conditionally in multiple tables.
• D. It can use views to produce source rows.
• E. It can merge rows only from tables.
• F. It can combine rows from multiple tables conditionally to insert into a single table.

Correct answer: A, D, F

Explanation

The correct answers A, D, and F highlight the capabilities of the MERGE statement, such as using subqueries and views for source data, and merging from multiple tables into one. Option B is incorrect because the MERGE statement does not update the same row multiple times in a single execution, while option C is misleading since it does not inherently perform operations across multiple tables simultaneously. Option E is also incorrect because the MERGE statement can source rows from views, not just tables.