Why is MERGE statement useful?

What will be an ideal response?

You can use the MERGE statement to perform INSERT and UPDATE operations
together on a table. This operation is very useful in data warehousing.

Computer Science & Information Technology

You might also like to view...

Which of the following Dynamic volume types is defined as having data on one disk that is replicated on the second disk? It requires two disks and is known as RAID Level 1

a. Simple b. Spanned c. Striped d. Mirrored

Computer Science & Information Technology

Registers are used to:

a. Store input data b. Temporarily store intermediate results c. Permanently store instructions d. None of the above e. a, b, and c

Computer Science & Information Technology