1Z0-007 · Question #103
Which three are true? (Choose three.)
The correct answer is A. A MERGE statement is used to merge the data of one table with data from 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. 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
Question
Which three are true? (Choose three.)
Options
- AA MERGE statement is used to merge the data of one table with data from another.
- BA MERGE statement replaces the data of one table with that of another.
- CA MERGE statement can be used to insert new rows into a table.
- DA MERGE statement can be used to update existing rows in a table.
How the community answered
(28 responses)- A75% (21)
- B25% (7)
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
Topics
Community Discussion
7
Grace U.Jun 27, 2026The correct answers are A, C, and D, because MERGE is essentially an upsert operation that combines INSERT and UPDATE logic, matching source rows to a target table and either updating existing rows when a match is found or inserting new ones when it is not. Option B trips people up, but "replace" is not what MERGE does, it merges conditionally rather than wholesale overwriting a table.
Dragan P.Jun 28, 2026Grace got the core right, but watch out, MERGE can also fire DELETE in the WHEN NOT MATCHED BY SOURCE clause (added behavior folks always forget), so calling it purely an "upsert" undersells what it can do in a full implementation.
Viktor S.Jun 5, 2026A is sloppy wording but B is just wrong, go A C D.
Dragan P.Jun 19, 2026Sat for the 007 back when MERGE was brand new in 9i and half the room picked B thinking "merge" meant overwrite, which it never did, because MERGE is upsert logic, WHEN MATCHED fires the UPDATE, WHEN NOT MATCHED fires the INSERT, and the table you are targeting keeps every row that does not touch the source. A, C, D is the only defensible pick, and if you are blanking on it during the exam just ask yourself whether a MERGE can ever delete a target row without an explicit WHEN NOT MATCHED BY SOURCE DELETE clause, the answer is no, which tells you immediately that B is nonsense.
Fatima Z.Jun 27, 2026Almost bubbled B, then A-C-D clicked. MERGE never fully replaces!
Wesley A.May 22, 2026B locks it, MERGE swaps target data out with source data.
Fatima Z.May 25, 2026Hey Wesley, good try but the answer is actually A, C, and D because MERGE can INSERT unmatched rows, UPDATE matched rows, and DELETE matched rows, all in one shot, think of it as the "IUD" of SQL statements. Option B describes neither locking nor a swap, so that one gets the boot.