Time Left - 06:00 mins

ESE 2021 Technical Quiz 127|| Transactions and concurrency control

Attempt now to get your rank among 61 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

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

Question 4

Consider the following action:

Transaction…..

Commit;

Rollback;

What does Rollback do?

Question 5

Which of the following is true?
  • 61 attempts
  • 0 upvotes
  • 1 comment
Jun 30ESE & GATE EC

Posted by:

Mayank SoniMayank SoniMember since Mar 2021
Share this quiz   |