Which three are true? (Choose three.)
A.
A MERGE statement is used to merge the data of one table with data from another.
B.
A MERGE statement replaces the data of one table with that of 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.
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