Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q3; There 3 parts to this question. Consider a table Bid(tem.price). There are initially two tuples in Bid: (phone, 10) and (laptop.20). We execute the
Q3; There 3 parts to this question. Consider a table Bid(tem.price). There are initially two tuples in Bid: (phone, 10) and (laptop.20). We execute the following two transactions concurrently: TI - S1 : update Bid set price- price + 5 S2: insert into Bid values (desktop, 3e) T2 S3: select sum(price) as s from Bid S4: select max(price) as m from Bid Transaction T1 always executes with isolation level Serializable. Assume both transactions successfully commit, and the individual statements S1, S2, S3, and S4 within the transactions each execute atomically. 6 a) If transaction T2 also executes with isolation level Serializable, which of the following pairs of values for the sum (s) and max (m) cannot be returned byT2? Why? s 30, m 30 All three pairs could be returned s 30, m 20 s 70, m 30 6 b) This question u ses the same tables and transactions specified above. If transaction T2 executes with isolation level Read Committed, which of the following pairs of values for the sum (s) and max (m) cannot be returned by T2? Justify your answer s 30, m 20 s 40, m 30 s 70, m 30 s 30, m 30 Cc) This question uses the same tables and transactions specified above. If transaction T2 executes with isolation level Read Uncommitted, which of the following pairs of values for the sum (s) and max (m) cannot be returned by T2? Justify your answer s 30, m 25 s 30, m 30 s 70, m 25 s 40, m 30
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started