Question:
What is the purpose of MERGE in sql server 2008?

Option A):
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that depends on a condition.
Option B):
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that is independent on a condition.
Option C):
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition.
Option D):
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that is independent on a condition.

Correct Answer is Option C):
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition.