Question

Which SQL statement needs both insert and update privilege on the target table and select privilege on the source table?

Select one:

delete

alter

merge

update​

Answer 1

Answer:

merge

Explanation:

MERGE is a deterministic statement — that is, you cannot update a row of the target table multiple times in the same MERGE statement. You must have the INSERT and UPDATE privileges on the target table and the SELECT privilege on the source table.