Interview Questions
1. What is SERIALZABLE Isolation Level?
A query in the current transaction cannot read data modified by another transaction that has not yet committed. No other
transaction can modify data being read by the current transaction until it completes, and no other transaction can insert new
rows that would match the search condition in the current transaction until it completes. As a result, the Serializable isolation
level prevents dirty reads, nonrepeatable reads, and phantom reads. However, it can have the biggest impact on performance,
compared to the other isolation levels.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment