Which Flashback technology would be the best choice to produce the list?

Over the course of a day, a department performed multiple DML statements (inserts,
updates, deletes) on multiple rows of data in multiple tables. The manager would like a
report showing the time, table name, and DML type for all changes that were made. Which
Flashback technology would be the best choice to produce the list?

Over the course of a day, a department performed multiple DML statements (inserts,
updates, deletes) on multiple rows of data in multiple tables. The manager would like a
report showing the time, table name, and DML type for all changes that were made. Which
Flashback technology would be the best choice to produce the list?

A.
Flashback Drop

B.
Flashback Query

C.
Flashback Transaction Query

D.
Flashback Versions Query

E.
Flashback Table

Show Hint

Leave a Reply 1

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

Jake from SF

Jake from SF

From https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS598

Oracle Flashback Query

Use this feature to retrieve data for an earlier time that you specify with the AS OF clause of the SELECT statement. For more information, see “Using Oracle Flashback Query (SELECT AS OF)”.

Oracle Flashback Transaction Query

Use this feature to retrieve metadata and historical data for a given transaction or for all transactions in a given time interval. To perform an Oracle Flashback Transaction Query, select from the static data dictionary view FLASHBACK_TRANSACTION_QUERY. For more information, see “Using Oracle Flashback Transaction Query”.

Typically, you use Oracle Flashback Transaction Query with an Oracle Flashback Version Query that provides the transaction IDs for the rows of interest (see “Using Oracle Flashback Transaction Query with Oracle Flashback Version Query”).

Reply