MERGE statement
Avoids separate updates
ncreases performance and ease of use
Is useful in data warehousing applications
All of the above