subject
Business, 28.06.2021 15:40 kaylam8346

A database contains a relation R(x) consisting of a set of integers --- i. e, tuples with one integer attribute. Alice, Betty, and Carol are each executing the following transactions: Alice's transaction:

START TRANSACTION;
SELECT sum(x) FROM R;
COMMIT;

Betty's transaction:

START TRANSACTION;
INSERT INTO R VALUES (5);
INSERT INTO R VALUES (15);
DELETE FROM R WHERE x=10;
COMMIT;

Carol's transaction:

START TRANSACTION;
DELETE FROM R WHERE x=5;
INSERT INTO R VALUES (10);
COMMIT;

Before any of these transaction execute, the sum of integers in R is 100, and none of these integers are 5, 10, or 15. If Alice's, Betty's, and Carol's transactions run at about the same time, and each runs under isolation level READ COMMITTED, what sums could be produced by Alice's transaction?

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 14:10
When a shortage or a surplus arises in the loanable funds market a. the supply of loanable funds changes to return the economy to its original real interest rate b. the nominal interest rate is pulled to the new equilibrium level c. the demand for loanable funds changes to return the economy to its original real interest rate d. the real interest rate is pulled to the new equilibrium level
Answers: 3
question
Business, 22.06.2019 14:30
If a product goes up in price, and the demand for it drops, that product's demand is a. elastic b. inelastic c. stable d. fixed select the best answer from the choices provided
Answers: 1
question
Business, 22.06.2019 23:00
Draw a flowchart for a process of interest to you, such as a quick oil-change service, a factory process you might have worked in, ordering a pizza, renting a car or truck, buying products on the internet, or applying for an automobile loan. identify the points where something (people, information) waits for service or is held in work-in-process inventory, the estimated time to accomplish each activity in the process, and the total flow time. evaluate how well the process worked and what might be done to improve it.
Answers: 2
question
Business, 23.06.2019 10:10
Type the correct answer in the box. spell all words correctly. what could be the cause for robert’s symptoms? every time a project deadline approached, robert became agitated, angry, and suffered from frequent headaches. his manager concluded that he was suffering from .
Answers: 3
You know the right answer?
A database contains a relation R(x) consisting of a set of integers --- i. e, tuples with one intege...
Questions
Questions on the website: 13722367