Which of the following is the default isolation level in SQL Server?

Options
- Read Committed
- Read Uncommitted
- Repeatable Read
- Serializable


CORRECT ANSWER : Read Committed

Discussion Board
READ COMMITTED

Read Committed is the default isolation level for all SQL Server databases. The isolation level uses shared locking or row versioning to prevent dirty reads, depending on whether the READ_COMMITTED_SNAPSHOT database option is enabled.

Prajakta Pandit 03-8-2017 11:12 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement