Question

The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________

(a) Cascading rollback

(b) Cascadeless rollback

(c) Cascade cause

(d) None of the mentioned

The question was posed to me in an online interview.

The question is from Transaction Isolation in section Transactions of RDBMS

Answer 1

The correct option is (a) Cascading rollback

Explanation: The phenomenon in which one failure leads to a series of transaction rollbacks is called as cascading rollback. B=It is named so because one failure causes the rollback of several other transactions serially.