Databases commit and rollback

Question

In order to undo the work of transaction after last commit which one should be used?
(A) View (B) Commit
(C) Rollback (D) Flashback

Comments

A rollback command can only be executed if the user has not performed the COMMIT command on the current transaction or statement.

---

My confusion is that rollback after commit??

---

Rollback

Answer 1

@jaimin19

(C) Rollback ....

Rollback work causes the current transaction to be rolled back; that is, it undoes all the updates performed by the SQL statements in the transaction....