A user performs an update on a table. Shortly after committing the transaction, they realize that they had an
error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to
undo this transaction and restore the table to its previous state?
A.
Flashback Drop
B.
Flashback Query
C.
Flashback Versions Query
D.
Flashback Transaction Query
E.
Flashback Table
Explanation:
FLASHBACK TABLE
Purpose
Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or
application error. The time in the past to which the table can be flashed back is dependent on the amount of
undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL
operations that change the structure of the table.