Question

If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

(a) Flashback

(b) Rollback

(c) Both Flashback and Rollback

(d) Cannot be done

I got this question in an interview for job.

This interesting question is from Transaction Atomicity and Durability topic in chapter Transactions of Database Management

Answer 1

Right choice is (d) Cannot be done

The best I can explain: Once committed the changes cannot be rolled back.