IBM Exam C2090-616 Topic 10 Question 7 Discussion

Actual exam question for IBM's C2090-616 exam

Question #: 7
Topic #: 10

Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?

AUPDATE t1 c1 = 'DB2, c2' = 11

BUPDATE t1 SET c1 = 'DB2, c2' = 11

CUPDATE t1 c1 = 'DB2', c2 = 11 WHERE c3 = 2016

DUPDATE t1 SET (c1, c2) = ('DB2', 11) = WHERE c3 = 2016

Show Suggested Answer

Suggested Answer: D

by Virgie at May 08, 2022, 12:03 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!