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