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