Free 70-461 Training Exam Question

70-461 Dumps PDF
Querying Microsoft SQL Server 2012

•     144 Questions With Answers
•     Updated Questions
•     70-461 Real Exams Question Answers
•     Just 1 day study required to pass exam
•     100% Passing Assurance
•     Money Back Guarantee
•     Free 3 Months Updates

Question No 15:
You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistoncal.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement. Which table hint should you use?

A.  HOLDLOCK
B.  ROWLOCK
C.  XLOCK
D.  UPDLOCK
E.  TABLOCK

Correct Answer: E
Explanation/Reference:
Reference: http://technet.microsoft.com/en-us/library/ms189857.aspx Reference: http://msdn.microsoft.com/en-us/library/ms187373.aspx

Education Certifications