Exam4Training

Which table hint should you use?

You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical.

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

Answer: E

Explanation:

Reference: http://technet.microsoft.com/en-us/library/ms189857.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms187373.aspx

Latest 70-461 Dumps Valid Version with 232 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version