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 = 22-mar-2007′ WHERE customer_id = (SELECT
customer_id FROM customers WHERE cust_last_name = ‘Roberts’AND Credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?
A.
It would not execute because the SELECT statement cannot be used in place of the table
name.
B.
It would not execute because two tables cannot be used in a single UPDATE statement.
C.
It would execute and restrict modifications to only the columns specified in the SELECT
statement.
D.
It would not execute because a subquery cannot be used in the WHERE clause of an
UPDATE statement.