047-174

174. 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

statement?

A. It would not execute because two tables cannot be used in a single UPDATE

statement.

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.

Answer: B

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718974/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718974/