Select from following answers:- It protects against phantom reads
- It causes the highest level of contention.
- It causes the highest level of blocking.
- All Above
Isolation level "SERIALIZABLE" in SQL Server:
Places a range lock on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. This is the most restrictive of the four isolation levels. Because concurrency is lower, use this option only when necessary. This option has the same effect as setting HOLDLOCK on all tables in all SELECT statements in a transaction.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator