Which transaction isolation level should you use in sp1?

You use SQL Server 2012 to store data used by an e-commerce application.
You develop a stored procedure named sp1. Sp1 is used to read the price of all the products sold on the ecommerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the price of a product.
Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?

You use SQL Server 2012 to store data used by an e-commerce application.
You develop a stored procedure named sp1. Sp1 is used to read the price of all the products sold on the ecommerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the price of a product.
Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?

A.
Serializable

B.
Snapshot

C.
Repeatable read

D.
Read committed



Leave a Reply 0

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