Which three are true about the MERGE statement? (Choose three.)
Which three are true about the MERGE statement? (Choose three.)
The MERGE statement can use subqueries to produce source rows, making option A correct. It is also true that the MERGE statement can use views to produce source rows, as stipulated in option D. Additionally, the MERGE statement can combine rows from multiple tables conditionally to insert into a single table, validating option F. Therefore, the correct options are A, D, and F.
https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_9016.htm#:~:text=This%20statement%20is%20a%20convenient,in%20the%20same%20MERGE%20statement.