OCP-1Z0-新051-61题版本-47
QUESTION NO: 47Which 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
版权声明:本文为博主原创文章,未经博主允许不得转载。
页:
[1]