What isolation level should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
A stored procedurein 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?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
A stored procedurein 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?

A.
SERIALIZABLE

B.
READ COMMITTED

C.
REPEATABLE READ

D.
READ UNCOMMITTED



Leave a Reply 0

Your email address will not be published. Required fields are marked *