Time Left - 06:00 mins
ESE 2021 Technical Quiz 127|| Transactions and concurrency control
Attempt now to get your rank among 85 students!
Question 1
An account A has amount Rs 500 and another account B has amount Rs 200. A transaction occurs between them and after the transaction, the amount in A becomes Rs 300 and the amount in B becomes Rs 400. Which property of transaction is proved in this scenario?
Question 2
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I. 2-phase locking
II. Time-stamp ordering
I. 2-phase locking
II. Time-stamp ordering
Question 3
Consider the following transaction involving two bank accounts x and y. Read (x); x: = x - 50; write(x); read(y); y: = y + 50; write(y)
The constraint that the sum of the accounts x and y should remain constant is that of
The constraint that the sum of the accounts x and y should remain constant is that of
Question 4
Consider the following action:
Transaction…..
Commit;
Rollback;
What does Rollback do?
Question 5
Which of the following is true?
- 85 attempts
- 0 upvotes
- 1 comment
Jun 30ESE & GATE EC
