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 non-repeatable 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