Home » Oracle » 1z0-051 » Which three are true?
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.
Correct Answer: ACD
Explanation/Reference:
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
Download Printable PDF. VALID exam to help you PASS.
|
|