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 is correct
Answer A is the correct.
A is the correct.
B, C and D are incorrect because the SET operator cannot be followed by more than one column name. If more than one column to be updated, they need to be separated by a comma
A is the correct answer
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;
That will be the finish of this report. Here you will discover some web-sites that we think you will enjoy, just click the links.
here are some links to web-sites that we link to because we believe they are really worth visiting
the time to read or go to the content or internet sites we’ve linked to beneath the
that is the finish of this post. Right here you will find some web pages that we feel you will appreciate, just click the links over
we like to honor numerous other world-wide-web web sites on the internet, even though they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
the time to read or go to the content material or websites we have linked to beneath the
below youll find the link to some web sites that we believe you’ll want to visit
here are some links to internet sites that we link to for the reason that we consider they may be worth visiting
Wonderful story, reckoned we could combine some unrelated information, nonetheless really worth taking a search, whoa did a single learn about Mid East has got more problerms also
we came across a cool web page that you just could get pleasure from. Take a look when you want
Here are several of the web sites we suggest for our visitors
Sites of interest we have a link to
The details mentioned inside the write-up are a number of the very best offered
Wonderful story, reckoned we could combine a handful of unrelated information, nonetheless genuinely really worth taking a search, whoa did one particular discover about Mid East has got more problerms at the same time
very couple of internet websites that happen to be detailed beneath, from our point of view are undoubtedly properly really worth checking out