Question

The _______ statement causes the statements to undo all the updates performed on the transaction

(a) Undo work

(b) Rollback work

(c) Commit work

(d) Replace work

I had been asked this question in my homework.

The origin of the question is Views and Transactions topic in chapter Intermediate and Advanced Sql of RDBMS

Answer 1

Correct choice is (b) Rollback work

For explanation I would say: The Rollback work statement causes the statements to undo all the updates performed on the transaction. The database is then restored to the state of what it was before the first statement of the transaction was executed.