oracle ocp 11g 051答,OCP-1Z0-新051-61题版本-47-Oracle

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