Your database has a table customer that contains the columns cust_name, amt_due, and old_status.
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query? external tables, temporary tables, fixed tables, or views
A.
Supplemental logging is not enabled for the database.
B.
The undo data that existed for versions of rows before the change to the table structure is invalidated.
C.
The db_flashback_retention_target parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
D.
Undo retention guarantee is not enabled.
E.
Flashback Data Archive is full after the first update statement.
Explanation:
Retrieves all the versions of the rows that exist between two points in time or two SCNs Retrieves only committed data Cannot be used to query
Can be used to create views
Cannot span DDL commands
Filters out segment shrink operations