1Z0-061 · Question #152
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…
The correct answer is A. UPDATE customers. Updating Two Columns with a Subquery You can update multiple columns in the SET clause of an UPDATE statement by writing multiple subqueries. The syntax is as follows: WHERE condition) WHERE condition)] [WHERE condition ] ;
Question
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?
Options
- AUPDATE customers
- BUPDATE customers
- CUPDATE customers
- DUPDATE customers
How the community answered
(66 responses)- A71% (47)
- B9% (6)
- C15% (10)
- D5% (3)
Explanation
Updating Two Columns with a Subquery You can update multiple columns in the SET clause of an UPDATE statement by writing multiple subqueries. The syntax is as follows: WHERE condition) WHERE condition)] [WHERE condition ] ;
Topics
Community Discussion
No community discussion yet for this question.