Select from following answers:- READ UNCOMMITTED
- READ COMMITTED

- SERIALIZABLE
- REPEATABLE READ
- All Above
READ COMMITTED specifies that statements cannot read data that has been modified but not committed by other transactions. This prevents dirty reads. Data can be changed by other transactions between individual statements within the current transaction, resulting in nonrepeatable reads or phantom data. This option is the SQL Server default.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator