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

Question

Exhibit

Options

• AThe statement will fail because a subquery cannot be used in an UPDATE statement.
• BThe statement will fail because the result set produced by the subquery will contain more than
• CThe statement will succeed; the last record retrieved by the subquery will be used to provide a
• DThe statement will succeed; the first record retrieved by the subquery will be used to provide a

• A
  11% (2)
• B
  79% (15)
• C
  5% (1)
• D
  5% (1)

No community discussion yet for this question.