Microsoft
70-433 · Question #115
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…
The correct answer is C. UPDATE Product SET Price = Price * 1.10. See the full explanation below for the reasoning.
Question
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?
Options
- AUPDATE Product SET Price = Price * 1.10,
- BUPDATE Product SET Price = Price * 1.10
- CUPDATE Product SET Price = Price * 1.10
- DUPDATE Product SET Price = Price * 1.10,
How the community answered
(44 responses)- A5% (2)
- B7% (3)
- C73% (32)
- D16% (7)
Community Discussion
No community discussion yet for this question.