Which code segment should you use?

You have a table named Product.
You need to increase product prices for only the vendor named Coho Winery by 10 percent and then
return a list of the products and updated prices.
Which code segment should you use?

You have a table named Product.
You need to increase product prices for only the vendor named Coho Winery by 10 percent and then
return a list of the products and updated prices.
Which code segment should you use?

A.
UPDATE Product
SET Price = Price * 1.10,
ProductName = ProductName
WHERE Product.VendorName = ‘Coho Winery’

B.
UPDATE Product
SET Price = Price * 1.10

OUTPUT inserted.ProductName, deleted.Price
WHERE Product.VendorName = ‘Coho Winery’

C.
UPDATE Product
SET Price = Price * 1.10
OUTPUT inserted.ProductName, inserted.Price
WHERE Product.VendorName = ‘Coho Winery’

D.
UPDATE Product
SET Price = Price * 1.10,
VendorName = ‘Coho Winery’
OUTPUT inserted.ProductName, inserted.Price



Leave a Reply 0

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