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

Other questions on the subject: Business

image
Business, 22.06.2019 17:30, chilanka
Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding
Answers: 2
image
Business, 22.06.2019 23:00, vipergod07
Customers arrive at rich dunn's styling shop at a rate of 3 per hour, distributed in a poisson fashion. rich can perform an average of 5 haircuts per hour, according to a negative exponential distribution. a) the average number of customers waiting for haircuts= customersb) the average number of customers in the shop= customersc) the average time a customer waits until it is his or her turn= minutesd) the average time a customer spends in the shop= minutese) the percentage of time that rich is busy= percent
Answers: 3
image
Business, 22.06.2019 23:10, najsha
Which of the following best explains the purpose of a strike? a. to pressure employers to increase the minimum wage. b. to make sure that producers don't make any profit. c. to get employers to submit to collective bargaining. d. to prevent employers from taking industrial action.
Answers: 2
image
Business, 23.06.2019 02:30, dragon2565
Suppose a starbucks tall latte cost $4.00 in the united states, 5.00 euros in the euro area and $2.50 australian dollars in australia. nominal exchange rates are .80 euros per dollar and 1.4 australian dollars per u. s. dollar. where does purchasing power parity hold? a. both the euro area and australia. b. neither the euro area or australia. c. the euro area but not australia. d. australia but not the euro area.
Answers: 1
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 in other subjects:

Konu
Mathematics, 20.05.2021 21:10
Konu
Mathematics, 20.05.2021 21:10
Konu
Mathematics, 20.05.2021 21:10
Konu
Mathematics, 20.05.2021 21:10
Konu
Mathematics, 20.05.2021 21:10