70-433 · Question #119
You have the following two tables. Products ProductID ProductName VendorID 1 Product1 0 2 Product2 1 3 Product3 1 4 Product4 0 ProductChanges ProductID ProductName VendorID 1 Product1 1 2 Product2 1…
The correct answer is B. ProductID ProductName VendorID. See the full explanation below for the reasoning.
Question
You have the following two tables. Products ProductID ProductName VendorID 1 Product1 0 2 Product2 1 3 Product3 1 4 Product4 0 ProductChanges ProductID ProductName VendorID 1 Product1 1 2 Product2 1 3 NewProduct3 2 5 Product5 1 You execute the following statement. MERGE Products USING ProductChanges ON (Products.ProductID = ProductChanges.ProductID) WHEN MATCHED AND Products.VendorID = 0 THEN DELETE WHEN MATCHED THEN UPDATE SET Products.ProductName = ProductChanges.ProductName Products.VendorID = ProductChanges.VendorID; You need to identify the rows that will be displayed in the Products table. Which rows will be displayed?
Options
- AProductID ProductName VendorID
- BProductID ProductName VendorID
- CProductID ProductName VendorID
- DProductID ProductName VendorID
How the community answered
(34 responses)- A6% (2)
- B79% (27)
- C3% (1)
- D12% (4)
Community Discussion
No community discussion yet for this question.