Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL problem. Please answer if youre 100% sure, and answer all parts for a thumbs up ! Problem1 Consider a database consisting of a single

SQL problem. Please answer if youre 100% sure, and answer all parts

for a thumbs up !

image text in transcribed

Problem1 Consider a database consisting of a single relation M: 10 a) The following two transactions T1 and T2 run concurrently on this database: T1 BEGIN TRANSACTION S1: update M set B B-10 where A-1 S2: update M set B = B+10 where A=2 COMMIT T2 BEGIN TRANSACTION S3: select sum(B) from M COMMIT Indicate at least one isolation level (if exist) that may make possible to see zero as output for T2. b) The following two transactions run concurrently on this database: T1 BEGIN TRANSACTION S1: insert into M values (3,100) COMMIT T2 BEGIN TRANSACTION S2: select sum(B) from M S3: select sum(B) from M; COMMIT For what isolation levels, T2 may see a different value as the output of the select sum(B) from M statements

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

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

Students also viewed these Databases questions