Consider a table Products(name, price). There are two tuples in Products: ('OK',2000) and ('Good',3000). Consider the following two concurrent transactions, each of which runs once and commits. Transaction 1 ----------------- Begin Transactioninsert into Products values (`Awesome',4000);update Products set price = price+300 where name=’OK’;commit; Transaction 2 -----------------Begin Transactionselect sum(price) from Products;select sum(price) from Products;commit; The databases serializability module stopped working. What possible values (consistent and inconsistent) can be obtained for the two sum(price) SELECT statements ? NOTE: The second transaction is consisting of only read statements. It may be scheduled between Transaction 1 and may read incosistent values.

ANSWER:- UPDATE TEST SET Y := (Y + 10) WHERE AID = 1; UPDATE TEST SET X := (X - 10) WHERE AID = 1;…

Answered: Consider a table Products(name, price).…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Consider a table Products(name, price). There are two tuples in Products: ('OK',2000) and ('Good',3000). Consider the following two concurrent transactions, each of which runs once and commits.

Transaction 1

-----------------

Begin Transaction

insert into Products values (`Awesome',4000);

update Products set price = price+300 where name=’OK’;

commit;

Transaction 2

-----------------

Begin Transaction

select sum(price) from Products;

commit;

The databases serializability module stopped working. What possible values (consistent and inconsistent) can be obtained for the two sum(price) SELECT statements ?

NOTE: The second transaction is consisting of only read statements. It may be scheduled between Transaction 1 and may read incosistent values.

Expert Solution