A table named DEPARTMENT contains the following data:
What will happen?
A. The statement will fail because a subquery cannot be used in an UPDATE statement.
B. The statement will fail because the result set produced by the subquery will contain more than one row.
C. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
D. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
|
Download Printable PDF. VALID exam to help you PASS. |
 |