View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. Evaluate the following UPDATE statement: UPDATE (SELECT order_date, order_total, customer_id FROM orders) SET order_date =…

Question

Exhibit

Options

• AIt would not execute because two tables cannot be used in a single UPDATE statement.
• BIt would execute and restrict modifications to only the columns specified in the SELECT statement.
• CIt would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
• DIt would not execute because the SELECT statement cannot be used in place of the table name.

• A
  14% (5)
• B
  74% (26)
• C
  9% (3)
• D
  3% (1)

No community discussion yet for this question.