ocpÌâ¿âÔõô±³£º11g-051-V9.02-µÚ165Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

165. View the Exhibit and examine the description for the CUSTOMERS table.

You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customer

with the CUST_ID 2360. You want the value for the CUST_INCOME_LEVEL to have the same value as

that of the customer with the CUST_ID 2560 and the CUST_CREDIT_LIMIT to have the same value as

that of the customer with CUST_ID 2566.

Which UPDATE statement will accomplish the task?

A. UPDATE customers

SET cust_income_level = (SELECT cust_income_level

FROM customers

WHERE cust_id = 2560),

cust_credit_limit = (SELECT cust_credit_limit

FROM customers

WHERE cust_id = 2566)

WHERE cust_id=2360;

B. UPDATE customers

SET (cust_income_level,cust_credit_limit) = (SELECT

cust_income_level, cust_credit_limit

FROM customers

WHERE cust_id=2560 OR cust_id=2566)

WHERE cust_id=2360;

C. UPDATE customers

SET (cust_income_level,cust_credit_limit) = (SELECT

cust_income_level, cust_credit_limit

FROM customers

WHERE cust_id IN(2560, 2566)

WHERE cust_id=2360;

D. UPDATE customers

SET (cust_income_level,cust_credit_limit) = (SELECT

cust_income_level, cust_credit_limit

FROM customers

WHERE cust_id=2560 AND cust_id=2566)

WHERE cust_id=2360;

Answer: A

ÊÔÌâ½âÎö£º

BCµÄ×Ó²éѯ·µ»ØµÄÊǶàÐУ¬ËùÓб¨´í¡£

DµÄ×Ó²éѯÌõ¼þ²»ÕýÈ·£¬

ÌâÒâ˵£º¸üÐÂCUST_IDΪ2360µÄCUST_INCOME_LEVELºÍCUST_CREDIT_LIMITÁÐÖµ¡£ÄãÏëÈÃCUST_INCOME_LEVELµÄÖµÓëCUST_IDΪ2560µÄÖµÒ»Ñù£¬ÈÃCUST_CREDIT_LIMITµÄÖµÓëCUST_IDΪ2566µÄÖµÒ»Ñù

°´ÌâÒ⣬ֻÓÐAÕýÈ·¡£