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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *