By default sql server has ___________ isolation level

Options
- READ COMMITTED
- READ UNCOMMITTED
- SERIALIZABLE
- REPEATABLE READ

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-6-2017 06:29 AM

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.)


Related Content

Advertisement
 
▲