____ is used to merge data from a source table into a target table.
A) MERGE
B) SELECT
C) INSERT
D) UPDATE

Question

Quizplus · Accepted Answer

MERGE statement is used to merge data from a source table into a target table based on a specified condition. It allows you to perform insert, update, or delete operations in a single statement, so it is the best choice for this scenario. The other options INSERT and UPDATE are used to insert new data or modify existing data in a table, but they cannot handle merging of multiple tables. SELECT statement is used to retrieve data from a table, but it does not modify tables.

____ Is Used to Merge Data from a Source Table