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, 21.06.2019 20:00
The maximum tax rate on estates and gifts
Answers: 1
question
Business, 22.06.2019 04:50
Allie and sarah decided that they want to purchase renters insurance for the apartment they share. they made a list of all of the items to be covered by the insurance policy, along with their estimated values. if the items to be covered total more than $3000, the insurance company charges an annual premium of 23% of the total value of the items. if the items to be covered total $3000 or less, the insurance company charges an annual premium of 20% of the total value of the items.
Answers: 1
question
Business, 22.06.2019 06:40
Self-interest achieve society’s economic goals because producers know which goods consumers want the most. as consumers and producers exercise their freedom to act in their own self-interest, markets will produce the desired goods at the lowest possible cost. consumers and producers both operate based on society’s economic goals. consumers know which goods can be produced at the lowest cost. there is a wide variety of desired goods and services in a market system because producers determine what to produce. consumers change their minds frequently. there is always a need to produce something new and improved. individual wants are diverse. what is produced is ultimately determined by consumers, because if the goods offered are not what consumers want, consumers will not buy them. producers, because they are driven by profits. producers, because they determine what to produce. consumers, because they participate in marketing surveys.
Answers: 2
question
Business, 22.06.2019 11:30
Leticia has worked for 20 years in the public relations department of a large firm and has been the vice-president for the past ten years. it is unlikely she will ever be promoted to the top executive position in her firm even though she has directed several successful projects and is quite capable. her lack of promotion is an illustration of (a) the "glass ceiling" (b) the "glass elevator" (c) the "mommy track" (d) sexual harassment
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: 13722363