A table named DEPARTMENT contains the following data: What will happen?

A.
The statement will fail because the result set produced by the subquery will contain more
than one row.

B.
The statement will succeed; the last record retrieved by the subquery will be used to
provide a WORKDEPT value for the update operation.

C.
The statement will fail because a subquery cannot be used in an UPDATE statement.

D.
The statement will succeed; the first record retrieved by the subquery will be used to
provide a WORKDEPT value for the update operation.