Select from following answers:- SET TRANSACTION ISOLATION LEVEL SNAPSHOT

- SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
- SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
- All Above
using SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement you can ensure that data read by any statement in a transaction will be transactionally consistent with how that data existed at the start of the transaction. SNAPSHOT transactions do not block other transactions from writing data.
Show Correct Answer
Source: measureup.com | |
Alert Moderator