READ Free Dumps For Microsoft- 70-461
Question ID 15126 | Your database contains tables named Products and ProductsPriceLog. The Products table |
Option A | UPDATE Products SET Price = Price * 1.05 OUTPUT inserted.ProductCode, deleted.Price, inserted.Price INTO ProductsPriceLog(ProductCode, OldPrice, NewPrice) |
Option B | UPDATE Products SET Price = Price * 1.05 OUTPUT inserted.ProductCode, inserted.Price, deleted.Price INTO ProductsPriceLog(ProductCode, OldPrice, NewPrice) |
Option C | UPDATE Products SET Price = Price * 1.05 OUTPUT inserted.ProductCode, deleted.Price, inserted.Price * 1.05 INTO ProductsPriceLog(ProductCode, OldPrice, NewPrice) |
Option D | UPDATE Products SET Price = Price * 1.05 INSERT INTO ProductsPriceLog(ProductCode, OldPrice, NewPrice) SELECT ProductCode, Price, Price * 1.05 FROM Products |
Correct Answer | A |
Question ID 15127 | You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are You need to display rows from the Orders table for the Customers row having the |
Option A | SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML RAW |
Option B | SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML RAW, ELEMENTS |
Option C | SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO |
Option D | SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId - Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO, ELEMENTS |
Option E | SELECT Name, Country, OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO |
Option F | SELECT Name, Country, OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO, ELEMENTS |
Correct Answer | A |