Câu 17: 70-461: MCSA Querying Microsoft SQL Server 2012/2014
You use Microsoft SQL Server to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which…
Nội dung câu hỏi
You use Microsoft SQL Server to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use?
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
- C. READ COMMITTED SNAPSHOT — đáp án hiện tại
- D. REPEATABLE READ
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.