Automatic Undo Management is enabled for your database.
You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval. Which three are prerequisites to fulfill this requirement?
A.
Minimal supplemental logging must be enabled.
B.
The database must be running in archivelog mode.
C.
Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
D.
The flashback any table privilege must be granted to the user.
E.
The select any transaction privilege must be granted to the user.
F.
The recycle bin parameter must be set to on.
C&D&E
ABE
Flashback Transaction Back-out: Prerequisites
Before a Flashback Transaction Backout operation can be activated, the DBA must make sure the following prerequisites have been addressed:
The database must be in ARCHIVELOG mode.
Supplemental logging must have been enabled at the database level; in addition, at a minimum, primary key level supplemental logging must be enabled on the tables for which FTB is desired.
Any user accounts other than SYS that will be participating in an FTB operation must have been granted the EXECUTE object privilege on package DBMS_FLASHBACK, and the SELECT ANY TRANSACTION system privilege.
Finally, any user account other than SYS must be granted FLASHBACK privileges on the table(s) on which FTB will be performed. Likewise, any user account that will be performing FTB must also either own the tables on which FTB will be performed, or have complete (SELECT, INSERT, UPDATE, and DELETE) DML privileges on those tables
ABE
ABE