OCP CBT Question 620

Please solve the following question.

A user reported an erroneous transaction that modified multiple rows across different tables, but they are unsure exactly which rows were affected or when the transaction occurred. You need to investigate all changes made by a specific transaction identified by its `UNDO_SQL`. Which view can be queried, possibly in conjunction with other information, to find the exact `UNDO_SQL` for a given SCN range or transaction ID, and what is a prerequisite for this view to show useful information?

sql-- Example scenario: A transaction with XID '080004008B010000' modified data.-- You want to see the undo operations for this transaction.

V$TRANSACTION; requires UNDO_RETENTION to be set.

DBA_FLASHBACK_ARCHIVE; requires a Flashback Data Archive.

FLASHBACK_TRANSACTION_QUERY; requires UNDO_RETENTION and supplemental logging.

V$UNDOSTAT; requires DB_FLASHBACK_RETENTION_TARGET to be enabled.