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?
A.
READ COMMITTED
B.
REPEATABLE READ
C.
SERIALIZABLE
D.
READ UNCOMMITTED