Which two are prerequisites for performing a flashback transaction?
A.
Flashback Database must be enabled.
B.
Undo retention guarantee for the database must be configured.
C.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user
flashing back transaction.
D.
Supplemental logging must be enabled.
E.
Recycle bin must be enabled for the database.
F.
Block change tracking must be enabled tor the database.
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS610
16.2.2 Configuring Your Database for Oracle Flashback Transaction Query
To configure your database for the Oracle Flashback Transaction Query feature, you or your database administrator must:
Ensure that Oracle Database is running with version 10.0 compatibility.
Enable supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
16.2.5 Granting Necessary Privileges
You or your database administrator must grant privileges to users, roles, or applications that must use these flashback features. For information about the GRANT statement, see Oracle Database SQL Language Reference.
For Oracle Flashback Query and Oracle Flashback Version Query
To allow access to specific objects during queries, grant FLASHBACK and either READ or SELECT privileges on those objects.
To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege.
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.
For DBMS_FLASHBACK Package
To allow access to the features in the DBMS_FLASHBACK package, grant the EXECUTE privilege on DBMS_FLASHBACK.
CD