Microsoft
70-433 · Question #116
70-433 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five products are priced at $10 per unit and have PriceIncrease set to 0. You have the following query: INSERT dbo.PriceChange (ProductID, Change, ChangeDate) SELECT ProductID, inPrice -delPrice, SYSDATETIME() FROM ( UPDATE dbo.Products SET Price *= 1.1 OUTPUT inserted.ProductID, inserted.Price, deleted.Price WHERE PriceIncrease = 1 ) p (ProductID, inPrice, delPrice); You need to predict the results of the query. Which results should the query produce?
Options
- AFive rows are updated in dbo.Products.
- BFive rows are updated in dbo.Products.
- CNo rows are updated in dbo.Products.
- DNo rows are updated in dbo.Products.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.