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

The MERGE statement (also known as UPSERT) combines INSERT and UPDATE operations into a single command, eliminating the need for separate statements. This improves performance, simplifies code, and is commonly used in data warehousing ETL processes.