You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure in a database uses a transaction to retrieve data from a table and produces aggregations. You must design a solution that meets the following requirements:

Update operations cannot be performed on the retrieved data while the

stored procedure is being executed.

Insert operations in the table can be performed while the stored

procedure is being executed. You need to ensure that the solution meets the requirements. What isolation level should you use?

Question

You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure in a database uses a transaction to retrieve data from a table and produces aggregations. You must design a solution that meets the following requirements:

Update operations cannot be performed on the retrieved data while the

stored procedure is being executed.

Insert operations in the table can be performed while the stored

procedure is being executed. You need to ensure that the solution meets the requirements. What isolation level should you use?

Accepted Answer

C. REPEATABLE READ

Answer

A. SERIALIZABLE

Answer

B. READ COMMITTED

Answer

D. READ UNCOMMITTED

You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure in a database uses a transaction to retrieve data from a table and produces…

Question

Options

How the community answered

Community Discussion