Which UPDATE statement will accomplish the task?

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?

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;



Leave a Reply 20

Your email address will not be published. Required fields are marked *


Gabriela Orz

Gabriela Orz

Answer A is the correct.

dba74

dba74

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

Ruth Kobus A is correct

Ruth Kobus A is correct

A is the correct answer

Hossam

Hossam

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;

Google

Google

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.

Fenster und Turen

Fenster und Turen

here are some links to web-sites that we link to because we believe they are really worth visiting

app builder

app builder

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

home decor

home decor

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

app builder

app builder

the time to read or go to the content material or websites we have linked to beneath the

drink coaster

drink coaster

below youll find the link to some web sites that we believe you’ll want to visit

Fenster

Fenster

here are some links to internet sites that we link to for the reason that we consider they may be worth visiting

live in care

live in care

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

online istikhara

online istikhara

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

mirar a este sitio web

mirar a este sitio web

Sites of interest we have a link to

インフルエンザ

インフルエンザ

The details mentioned inside the write-up are a number of the very best offered

Drei Shop Innsbruck Hall

Drei Shop Innsbruck Hall

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

Car care

Car care

very couple of internet websites that happen to be detailed beneath, from our point of view are undoubtedly properly really worth checking out