Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions