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?
A.
SNAPSHOT
B.
SERIALIZABLE
C.
READ COMMITTED
D.
READ UNCOMMITTED