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?

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



Leave a Reply 0

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