ایس کیو ایل سرور کے ذریعہ فراہم کردہ سب سے سخت ٹرانزیکشن آئسولیشن لیول کیا ہے؟
A. READ COMMITTED
B. SERIALIZABLE
C. READ UNCOMMITTED
D. REPEATABLE READ
Explanation
The SERIALIZABLE isolation level is the strictest transaction isolation level provided by SQL Server. It ensures that transactions are executed in a serialized manner, as if they were the only transaction operating on the database. This means that:
No other transactions can modify data being read by a transaction.
No other transactions can insert new data that would affect the results of a transaction.
No other transactions can delete data that a transaction is using.
