Q
What does the MERGE statement do?
-
A
Joins two databases together
-
B
Merges two tablespaces
-
C
Deletes duplicate tables
-
D
Inserts new rows or updates existing rows in a single statement
Correct Answer:
D. Inserts new rows or updates existing rows in a single statement
Explanation:
MERGE (upsert) uses WHEN MATCHED THEN UPDATE and WHEN NOT MATCHED THEN INSERT.
