Which three are true? (Choose three.)

The correct answer is A. A MERGE statement is used to merge the data of one table with data from another. C. A MERGE statement can be used to insert new rows into a table. D. A MERGE statement can be used to update existing rows in a table. The MERGE Statement allows you to conditionally insert or update data in a table. If the rows are present in the target table which match the join condition, they are updated if the rows are not present they are inserted into the target table

Manipulating Data

Question

Options

AA MERGE statement is used to merge the data of one table with data from another.
BA MERGE statement replaces the data of one table with that of another.
CA MERGE statement can be used to insert new rows into a table.
DA MERGE statement can be used to update existing rows in a table.

How the community answered

(24 responses)

A
79% (19)
B
21% (5)

Explanation

The MERGE Statement allows you to conditionally insert or update data in a table. If the rows are present in the target table which match the join condition, they are updated if the rows are not present they are inserted into the target table

Topics

#MERGE statement#INSERT#UPDATE#DML operations

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice