Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume a database is being used simultaneously in two different sessions, as follows: Step Session 1 Session 2 CREATE TABLE X a VARCHAR(64), b INTEGER,
Assume a database is being used simultaneously in two different sessions, as follows: Step Session 1 Session 2 CREATE TABLE X a VARCHAR(64), b INTEGER, PRIMARY KEY(a) CREATE TABLE Y (g VARCHAR(10)) START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED INSERT INTO X (a, b) VALUES (Jeff, 10); COMMIT START TRANSACTION READ WRITE, ISOLATION LEVEL isolation level SELECT FROM Y START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 11 WHERE a 'Jeff' COMMIT 10 SELECT b FROM X WHERE a = 'Jeff START TRANSACTION READ WRITE, 12 13 14 ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 12 WHERE a 'Jeff' COMMIT START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 13 WHERE a = 'Jeff' 15 16 17 SELECT b FROM X WHERE a = 'Jeff' COMMIT For each possible value for isolation_level in step 5 (READ UNCOMMITED, READ COMMITTED REPEATABLE READ, and SERIALIZABLE) . what value is returned by the query in step 16? And, describe why that value is returned. Assume a database is being used simultaneously in two different sessions, as follows: Step Session 1 Session 2 CREATE TABLE X a VARCHAR(64), b INTEGER, PRIMARY KEY(a) CREATE TABLE Y (g VARCHAR(10)) START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED INSERT INTO X (a, b) VALUES (Jeff, 10); COMMIT START TRANSACTION READ WRITE, ISOLATION LEVEL isolation level SELECT FROM Y START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 11 WHERE a 'Jeff' COMMIT 10 SELECT b FROM X WHERE a = 'Jeff START TRANSACTION READ WRITE, 12 13 14 ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 12 WHERE a 'Jeff' COMMIT START TRANSACTION READ WRITE, ISOLATION LEVEL READ COMMITTED UPDATE X SET b = 13 WHERE a = 'Jeff' 15 16 17 SELECT b FROM X WHERE a = 'Jeff' COMMIT For each possible value for isolation_level in step 5 (READ UNCOMMITED, READ COMMITTED REPEATABLE READ, and SERIALIZABLE) . what value is returned by the query in step 16? And, describe why that value is returned
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