Which Flashback option would allow you to undo this transaction and restore the table to its previous state?

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

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

two × one =

Stefano

Stefano

Only the Flashback Table operation RECOVERS a table to a previous point in time. The other options allow VIEWING of past states of the data (B,C,D,) or restoring the Recycle Bin (A), but they do NOT RECOVER a table to a previous point in time.

Reply