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
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 如果目标表和现在表的行符合联合条件,就会更新行插入目标表