The MERGE statement is a standard SQL command designed to synchronize data between a source and a target table. It evaluates a condition to determine whether a row exists in the target table. Based on the outcome, it can perform an INSERT (if the row does not exist), an UPDATE (if the row exists and meets certain criteria), or a DELETE (if the row exists in the target but not the source, or meets other criteria). This consolidation of multiple Data Manipulation Language (DML) operations into a single, atomic statement is highly efficient for tasks like data warehousing and maintaining data consistency.

A. INTO: The INTO keyword is used within an INSERT statement to specify the destination table for new rows.

B. JOIN: The JOIN clause is used in SELECT, UPDATE, or DELETE statements to combine rows from two or more tables.

D. DROP: The DROP command is a Data Definition Language (DDL) statement used to delete entire database objects, such as tables.

---

1. Oracle Corporation. (2023). Oracle Database SQL Language Reference, 23c. "MERGE Statement". This official documentation states, "Use the MERGE statement to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or to insert into the target table or view. This statement is a convenient way to combine multiple operations. It lets you avoid multiple INSERT, UPDATE, and DELETE DML statements."

2. Microsoft Corporation. (2024). MERGE (Transact-SQL). SQL Server Documentation. In the "Remarks" section, it is stated: "Performs insert, update, or delete operations on a target table from the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table."

3. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. In Chapter 4, "Intermediate SQL," Section 4.5, "Modifications of the Database," the text describes the MERGE statement: "The merge construct allows the combination of an insert and an update... Some database systems, such as Oracle and Microsoft SQL Server, also allow a delete clause..." (p. 153).