PrepAway - Latest Free Exam Questions & Answers

Which transaction isolation level should you use?

You have a transaction that uses the repeatable read isolation level.
This transaction causes frequent blocking problems. You need to reduce blocking. You also need to
avoid dirty reads and nonrepeatable
reads. Which transaction isolation level should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
SNAPSHOT

B.
SERIALIZABLE

C.
READ COMMITTED

D.
READ UNCOMMITTED


Leave a Reply