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