SQL Server Locks Question:
Download Job Interview Questions and Answers PDF
Do you know the isolation level that SQL Server support?
Answer:
Isolation levels supported by SQL Server:
Read uncommitted: Lowest level of isolation
Read committed: Default
Repeatable read
Serializable: Highest level of isolation. All transactions are isolated from each other completely.
Read uncommitted: Lowest level of isolation
Read committed: Default
Repeatable read
Serializable: Highest level of isolation. All transactions are isolated from each other completely.
Download MS SQL Server Locks Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Pessimistic concurrency? | Explain isolation levels that SQL server supports? |