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 customersSET cust_income_level = (SELECT cust_income_levelFROM customersWHERE cust_id = 2560),cust_credit_limit = (SELECT cust_credit_limitFROM customersWHERE cust_id = 2566)WHERE cust_id=2360;
B. UPDATE customersSET (cust_income_level,cust_credit_limit) = (SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id=2560 OR cust_id=2566)WHERE cust_id=2360;
C. UPDATE customersSET (cust_income_level,cust_credit_limit) = (SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id IN (2560, 2566)WHERE cust_id=2360;
D. UPDATE customersSET (cust_income_level,cust_credit_limit) = (SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id=2560 AND cust_id=2566)WHERE cust_id=2360;
|
Download Printable PDF. VALID exam to help you PASS. |
 |