Oracle
1Z0-071 · Question #267
Which three are true about the MERGE statement? (Choose three.)
The correct answer is C. It can use subqueries to produce source rows. D. It can update, insert, or delete rows conditionally in multiple tables. F. It can use views to produce source rows. See the full explanation below for the reasoning.
Question
Which three are true about the MERGE statement? (Choose three.)
Options
- AIt can combine rows from multiple tables conditionally to insert into a single table.
- BIt can merge rows only from tables.
- CIt can use subqueries to produce source rows.
- DIt can update, insert, or delete rows conditionally in multiple tables.
- EIt can update the same row of the target table multiple times.
- FIt can use views to produce source rows.
How the community answered
(24 responses)- B13% (3)
- C79% (19)
- E8% (2)
Community Discussion
No community discussion yet for this question.