Question
5. Exe. 6.6.3 (30 pts). Base your answers on the SQL standard definitions of isolation levels. Use the following format for your answers: (a) when
5. Exe. 6.6.3 (30 pts). Base your answers on the SQL standard definitions of isolation levels. Use the following format for your answers: (a) when T is the READ ONLY transaction from 6.6.1(a) If another READ ONLY transaction runs concurrently 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is deleteModel from 6.6.1 (b), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (b) when T is the deleteModel transaction from 6.6.1(b) If the other concurrent transaction is deleteModel from 6.6.1 (b), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (c) when T is the updatePCPrice transaction from 6.6.1(c) If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (d) when T is the insertPC transaction from 6.6.1(d) If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable,
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