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

3 Comments

A rollback command can only be executed if the user has not performed the COMMIT command on the current transaction or statement.
0
0
My confusion is that rollback after commit??
0
0
Rollback
0
0

1 Answer

0 votes
0 votes

@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....

by