subject

A database has two tables Rand S with 100 tuples each. Exactly two transactions, 11 and T2, execute concurrently on the database. T1 inserts a tuple in R and after some time decides to abort. T2 computes the difference: SELECT count(*) from R - SELECT count(*) from s and inserts as many tuples in S. After the transactions complete, R has 100 tuples and S has 101 tuples. Which of the following is possible? a. The transactions executed in the REPEATABLE READ isolation level.
b. The transactions executed in the READ UNCOMMITTED isolation level.
C. The transactions executed in the READ COMMITTED isolation level.
d. This outcome is not possible in any of these isolation levels.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 18:30
If an improvement creates no significant change in a product’s performance, then it is a(n) ? a0 design improvement. (there are no answer choices)
Answers: 1
question
Computers and Technology, 25.06.2019 04:00
Has anyone noticed that has been giving the wrong answers and that the ads are blocking answers or is that just me?
Answers: 2
question
Computers and Technology, 25.06.2019 08:30
Which of these devices is usually the default for most home network?
Answers: 1
question
Computers and Technology, 25.06.2019 08:40
Anyone took cgs 1060 and took exam for simnet, slide 50 question on 1st exam.
Answers: 3
You know the right answer?
A database has two tables Rand S with 100 tuples each. Exactly two transactions, 11 and T2, execute...
Questions
question
Mathematics, 17.03.2021 23:40
question
Physics, 17.03.2021 23:40
question
Computers and Technology, 17.03.2021 23:40
Questions on the website: 13722360