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 21:40
Tandard product costs deerfield company manufactures product m in its factory. production of m requires 2 pounds of material p, costing $4 per pound and 0.5 hour of direct labor costing, $10 per hour. the variable overhead rate is $8 per direct labor hour, and the fixed overhead rate is $12 per direct labor hour. what is the standard product cost for product m? direct material answer direct labor answer variable overhead answer fixed overhead answer standard product cost per unit answer
Answers: 1
question
Business, 21.06.2019 21:40
This problem has been solved! see the answerchapter 19 problem #8. quality and financial control (connect, perform)part one: geometrica designs and builds domes and space frames for large buildings. while the company had developed quality standards over time to respond to different client problems and training needs, it lacked a unified quality system, and its global client base wanted assurance that geometrica met an established international standard for quality. which of the following was an appropriate step for this company to take? a) reform its accounting and financial reporting systems to comply with sarbanes-oxleyb) establish and document a quality management system to comply with iso 9000management at workyou are the new fleet manager at xpressship, a package delivery company. as your first project, your boss has asked that you to look into implementing an electronic monitoring system for the fleet of 2,000 trucks your company owns. a recent internal audit on maintenance and repair costs on the company’s vehicles revealed while maintenance was performed regularly on the trucks, mileage or use had not been taken into account. this resulted in approximately $20,000 of unneeded repairs. you know that telematics have been used by other companies with fleets of cars or trucks and it will allow your company to not only track mileage and use, but also part replacement needs, vehicle oil pressure, and drivers’ speed and real time location. tracking these items can reduce maintenance costs while improving efficiency. you find that a simple computer can be installed in each vehicle. when the drivers return at the end of the day, the telematics information from each vehicle will be uploaded to a master computer where a software program will generate a report with results on the variables you have selected.early one morning as you are getting a cup of coffee, a few drivers that have been with the company for many years approach you with some concerns. eldon, the most senior driver says, “i heard you’re installing some type of computer to track our driving. my buddy works over at parcel and post package delivery and he said they’ve got these computers, too. he said managers are writing people up and firing drivers for speeding or not wearing seat belts. are you going to do that to us, too? ”part two: as a manager, which of the following statements would be effective in maintaining a positive relationship with company drivers? check all that apply.a) at this time, xpressship will be using telematics to monitor maintenance and repair needs, not drivers’ motoring habitsb) although the company isn’t doing so now, when xpressship begins to monitor driver motoring habits, the company will encourage them to keep a separate daily log where they can document any unusual circumstancesc) while xpressship could monitor things like speed, location, and idle time, the company trusts their drivers and will not be using that data in disciplinary decisionsd) xpressship executives are happy with their technology and believe that implementation is ideal for your organization
Answers: 3
question
Business, 21.06.2019 21:40
Prior to its closing, income summary had total debits of $1,190,500 and total credits of $1,476,300. what purpose is served by the income summary account and what is the nature of the entries that resulted in the $1,190,500 and the $1,476,300? the income summary account is used to the accounts. the $1,190,500 represents the , and the $1,476,300 represents . the company had of $ .
Answers: 1
question
Business, 22.06.2019 03:00
What is the relationship between marginal external cost, marginal social cost, and marginal private cost? a. marginal social cost equals marginal private cost plus marginal external cost. b. marginal private cost plus marginal social cost equals marginal external cost. c. marginal social cost plus marginal external cost equals marginal private cost. d. marginal external cost equals marginal private cost minus marginal social cost. marginal external cost a. is expressed in dollars, so it is not an opportunity cost b. is an opportunity cost borne by someone other than the producer c. is equal to two times the marginal private cost d. is a convenient economics concept that is not real
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
question
Mathematics, 17.12.2020 19:40
question
Chemistry, 17.12.2020 19:40
question
Mathematics, 17.12.2020 19:40
question
Arts, 17.12.2020 19:40
question
Mathematics, 17.12.2020 19:40