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,cust_credit_limit) = (SELECT
cust_income_level, cust_credit_limit FROM customers WHERE cust_id=2560 OR
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 IN(2560, 2566)
WHERE cust_id=2360;
C.
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;
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;