Examine this SQL statement: Which two are true?

Question

Exhibit

Options

• AAll existing rows in the ORDERS table are updated
• BThe subquery is executed for every updated row in the ORDERS table
• CThe subquery is executed before the UPDATE statement is executed
• DThe subquery is not a correlated subquery
• EThe UPDATE statement executes successfully even if the subquery selects multiple rows

• B
  3% (1)
• C
  6% (2)
• D
  83% (30)
• E
  8% (3)

Explanation

Explanation/Reference:

No community discussion yet for this question.