All existing rows in the ORDERS table are updated.

The subquery is executed before the UPDATE statement is executed.

The subquery is not a correlated subquery.

The subquery is executed for every updated row in the ORDERS table.

The UPDATE statement executes successfully even if the subquery selects multiple rows.