Questions tagged [repeatable-read]

Table R (A) containing the records [(3), (4), (5)] and transactions T1 = UPDATE R SET A = A * 2; INSERT INTO A VALUES (6); and T2 = 'SELECT AVG (A) FROM R; SELECT AVG (A) FROM R' Knowing that transaction T2 is executed using repeatable-read which…