117. 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 = '22mar2007' 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
A. It would not execute because two tables cannot be used in a single UPDATE
B. It would execute and restrict modifications to only the columns specified
in the SELECT statement.
C. It would not execute because a subquery cannot be used in the WHERE clause
of an UPDATE statement.
D.It would not execute because the SELECT statement cannot be used in place
of the table name.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718925/，如需转载，请注明出处，否则将追究法律责任。