Multiple choice technology databases

MERGE statement

  1. Avoids separate updates

  2. ncreases performance and ease of use

  3. Is useful in data warehousing applications

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

MERGE statement (also called UPSERT) combines INSERT and UPDATE operations in one statement. It avoids writing separate UPDATE and INSERT statements for the same data. This increases performance (single pass over data, reduced overhead) and ease of use (one statement instead of multiple). MERGE is particularly useful in data warehousing for slowly changing dimensions, ETL processes, and synchronization scenarios where you need to update existing rows or insert new ones based on a match condition.

Keep practicing — related questions