nerdexam
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)
  • B
    13% (3)
  • C
    79% (19)
  • E
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice