Câu 64: 70-464: Developing Microsoft SQL Server 2012/2014 Databases
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 e-commerce site. You need to ensure that sp1 can read data even while another transaction is modifying the price of a product. Sp1 must only r…
Nội dung câu hỏi
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 e-commerce 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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Serializable
- B. Snapshot — đáp án hiện tại
- C. Repeatable read
- D. Read committed
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.