Free C2090-730 Web TestEngine Demo

Exit VCEDump C2090-730 DB2 9 Family Fundamentals

Q30 Single choice

Given the following UPDATE statement: UPDATE employees SET workdept =
(SELECT deptno FROM department WHERE deptno = 'A01') WHERE workdept IS NULL

Which of the following describes the result if this statement is executed?

A
The statement will fail because an UPDATE statement cannot contain asubquery.
B
The statement will only succeed if the data retrieved by thesubquery does not contain multiple records.
C
The statement will succeed; if the data retrieved by thesubquery contains multiple records, only the first
record will be used to perform the update.
D
The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.

Previous Check answer

Question map30 / 46

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46

Current Correct Answered Incorrectly Reviewed 0 Remaining 46

Marked Questions0

No marked questions.

Answered Incorrectly0

No incorrect answers.

C2090-730 Web TestEngine demo