Question: Urgent help please! Consider the following table XboxGames ( id , name, price ) and assume that these values already exist in the database: (

Urgent help please! Consider the following table XboxGames(id, name, price) and assume that these values already exist in the database:
(1,'Bad game', 10),(2,'Ok game', 30),(3, 'good game, 40),(4,'AWESOME game', 100).
We have the following two transactions:
T1: BEGIN TRANSACTION
SELECT AVG (price) AS average price FROM XboxGames ;
COMMIT;
T2: BEGIN TRANSACTION
UPDATE XboxGames SET Price =40 WHERE name = 'good game'
COMMIT;
INSERT INTO XboxGames VALUES (' Terrific Game', 60);
T3: BEGIN TRANSACTION
UPDATE XboxGames SET Price=price*1.20
COMMIT;
The above three transactions are hitting the DBMS roughly at the same time.
What are the possible values for Transaction 1.
 Urgent help please! Consider the following table XboxGames(id, name, price) and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!