Exit 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Question 1 of 5
0% complete
Q1 Single choice

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?

  • A

    READPAST

  • B

    HOLDLOCK

  • C

    TABLOCKX

  • D

    READCOMMITTED

Previous Next