AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Microsoft- 70-462





Question ID 18893

You administer a Microsoft SQL Server 2012 database that contains a table named
OrderDetail.
You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented.
You need to reduce fragmentation. You need to achieve this goal without taking the index
offline.
Which Transact-SQL batch should you use?

Option A

CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING

Option B

ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE

Option C

ALTER INDEX ALL ON OrderDetail REBUILD

Option D

ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

Correct Answer B
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms188388.aspx


Question ID 18894

Your database contains tables named Products and ProductsPriceLog. The Products table
contains columns named ProductCode and Price. The ProductsPriceLog table contains
columns named ProductCode, OldPrice, and NewPrice. The ProductsPriceLog table stores
the previous price in the OldPrice column and the new price in the NewPrice column.
You need to increase the values in the Price column of all products in the Products table by
5 percent.
You also need to log the changes to the ProductsPriceLog table.
Which Transact-SQL query should you use?

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 * INTO ProductsPriceLog(ProductCode, OldPrice, NewPrice)

Option D

UPDATE Products SET Price = Price * 1.05 INSERT INTO ProductsPriceLog (ProductCode, CldPnce, NewPrice; SELECT ProductCode, Price, Price * 1.05 FROM Products

Correct Answer A
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms177564.aspx

Send email to admin@getfreedumps for new dumps request!!!