IBM

C2090-320 · Question #65

Which SQL statement supports an insert or an update in a single SQL statement?

The correct answer is A. MERGE. https://stackoverflow.com/questions/330241/does-db2-have-an-insert-or-update-statement

SQL

Question

Which SQL statement supports an insert or an update in a single SQL statement?

Options

AMERGE
BUPSERT
CUPDATE or INSERT INTO ...
DINSERT INTO table ... ON DUPLICATE KEY ...

How the community answered

(33 responses)

A
73% (24)
B
9% (3)
C
3% (1)
D
15% (5)

Explanation

https://stackoverflow.com/questions/330241/does-db2-have-an-insert-or-update-statement

Topics

#MERGE statement#DML#insert-update#SQL syntax

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-320 Practice