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.
ABE
16.2.3 Configuring Your Database for Flashback Transaction
To configure your database for the Flashback Transaction feature, you or your database administrator must:
With the database mounted but not open, enable ARCHIVELOG:
ALTER DATABASE ARCHIVELOG;
Open at least one archive log:
ALTER SYSTEM ARCHIVE LOG CURRENT;
If not done, enable minimal and primary key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
If you want to track foreign key dependencies, enable foreign key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;
For Oracle Flashback Transaction Query
Grant the SELECT ANY TRANSACTION privilege.
To allow execution of undo SQL code retrieved by an Oracle Flashback Transaction Query, grant SELECT, UPDATE, DELETE, and INSERT privileges for specific tables.
ABE