Assuming three isolation levels, REPEATABLE READ, READ COMMITTED, and READ UNCOMMITTED, what name would be returned...

 

Transcribed Image Text:

Assuming three isolation levels, REPEATABLE READ, READ COMMITTED, and READ UNCOMMITTED, what name would be returned after executing "SELECT name FROM roaster WHERE id = 7;"? REPEATABLE READ (d) (e) (1) (g) READ COMMITTED READ UNCOMMITTED Transaction 4 begins Transaction 4 ends Transaction 5 begins Transaction 5 ends Transaction 4 UPDATE roster SET name="Mary WHERE id= 7 COMMIT Transaction 5 UPDATE roster SET name='Amy' WHERE id=7 ROLLBACK time Table: roster id 3 7 id 3 7 id 3 7 id 3 7 name Mike Jane name Mike Mary name Mike | Amy name Mike Mary Transaction 3 SELECT name FROM roster WHERE id = 7 SELECT name FROM roster WHERE id = 7 SELECT name FROM roster WHERE id= 7 SELECT name FROM roster WHERE id = 7 time Transaction 3 begins (d) (e) (f) (8) Transaction 3 ends Assuming three isolation levels, REPEATABLE READ, READ COMMITTED, and READ UNCOMMITTED, what name would be returned after executing "SELECT name FROM roaster WHERE id = 7;"? REPEATABLE READ (d) (e) (1) (g) READ COMMITTED READ UNCOMMITTED Transaction 4 begins Transaction 4 ends Transaction 5 begins Transaction 5 ends Transaction 4 UPDATE roster SET name="Mary WHERE id= 7 COMMIT Transaction 5 UPDATE roster SET name='Amy' WHERE id=7 ROLLBACK time Table: roster id 3 7 id 3 7 id 3 7 id 3 7 name Mike Jane name Mike Mary name Mike | Amy name Mike Mary Transaction 3 SELECT name FROM roster WHERE id = 7 SELECT name FROM roster WHERE id = 7 SELECT name FROM roster WHERE id= 7 SELECT name FROM roster WHERE id = 7 time Transaction 3 begins (d) (e) (f) (8) Transaction 3 ends

Answer rating: 100% (QA)

From the series of transactions displayed we can determine what the result would be for the SELECT name FROM roster WHERE id 7 query under different i... View the full answer