You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the stored procedure cannot perform dirty reads.
What should you do?
A.
You should configure the stored procedure to use the READ UNCOMMITTED isolation level.
B.
You should configure the stored procedure to use the READ COMMITTED isolation level.
C.
You should configure the stored procedure to use the SERIALIZABLE isolation level.
D.
You should configure the stored procedure to use the REPEATABLE READ isolation level.
E.
You should configure the stored procedure to use the SNAPSHOT isolation level.
Explanation: