QUESTION NO: 47
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.
Answer: A,C,D
答案解析：
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