Question: Assuming three isolation levels, REPEATABLE READ, READ COMMITTED, and READ UNCOMMITTED, what name would be returned after executing SELECT name FROM roaster WHERE id
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
Step by Step Solution
There are 3 Steps involved in it
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 full answer
Get step-by-step solutions from verified subject matter experts
