Correct answer is no one, the best is D as there is typo error on that.
[db2inst2@vbox1 ~]$ db2 "UPDATE t1 SET (c1, c2) = ('~DB2', 11) = WHERE c3 = 2016"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "c3" was found following "('~DB2', 11) = WHERE".
Expected tokens may include: "<space>". SQLSTATE=42601
[db2inst2@vbox1 ~]$ db2 "UPDATE t1 SET (c1, c2) = ('~DB2', 11) WHERE c3 = 2016"
DB20000I The SQL command completed successfully.
it is but has two typos, correct line is:
UPDATE t1 SET (c1, c2) = ('DB2', 11) WHERE c3 = 2016
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JamesBond
3 years, 4 months agodb2tester
5 years, 1 month agozarko
4 years, 1 month ago