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, UPDATE, and DELETE operations into a single statement, which avoids writing separate update statements. It is commonly used in data warehousing applications for ETL processes and can improve performance by reducing round trips to the database. The typo 'ncreases' in option B should be 'Increases'.

Keep practicing — related questions