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 combines INSERT and UPDATE actions in a single command, avoiding separate DML statements, improving performance, and simplifying data‑warehouse load processes where upserts are common. All listed benefits are accurate, so the “All of the above” choice correctly captures them.

Keep practicing — related questions