Microsoft
70-451 · Question #24
You are a database developer. You plan to create a database by using SQL Server 2008. A database contains a table named Sales. The Sales table contains customer order summary information. You create…
The correct answer is C. TABLOCKX. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to create a database by using SQL Server 2008. A database contains a table named Sales. The Sales table contains customer order summary information. You create a stored procedure that uses a SELECT statement. At the moment of execution, the procedure must return a precise summation of the total sales for the current day. You need to use a query hint to prevent any data modification in the Sales table when the stored procedure is being executed. Which query hint should you recommend?
Options
- AREADPAST
- BHOLDLOCK
- CTABLOCKX
- DREADCOMMITTED
How the community answered
(40 responses)- A3% (1)
- B13% (5)
- C78% (31)
- D8% (3)
Community Discussion
No community discussion yet for this question.