Microsoft
70-457 · Question #17
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…
The correct answer is E. TABLOCK. See the full explanation below for the reasoning.
Question
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?
Options
- AHOLDLOCK
- BROWLOCK
- CXLOCK
- DUPDLOCK
- ETABLOCK
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C7% (2)
- E79% (23)
Community Discussion
No community discussion yet for this question.