Which SQL statement needs both insert and update privilege on the target table and select privilege on the source table?
Answer options
A
MERGE
B
INSERT
C
UPDATE
D
DELETE
Correct answer: MERGE
Explanation
Quick AnswerThe correct answer is MERGE because it directly addresses the core logic of Database Management.
MERGE (upsert) requires both INSERT and UPDATE privileges on the target table.