（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;

答案：（A）

ITPub博客

OCP 1Z0-051 165