Interview Questions
1. What is REPEATABLE READ Isolation Level?
A query in the current transaction cannot read data modified by another transaction that has not yet committed, thus
preventing dirty reads. In addition, no other transactions can modify data being read by the current transaction until it
completes, eliminating nonrepeatable reads. However, if another transaction inserts new rows that match the search
condition in the current transaction, in between the current transaction accessing the same data twice, phantom rows can
appear in the second read.
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