Which are the prerequisites for performing flashback transactions on your database? (Choose all
that apply.)
A.
Undo retention guarantee for the database must be configured.
B.
Supplemental log must be enabled for the primary key.
C.
Supplemental log must be enabled.
D.
Execute permission on the DBMS_FLASHBACK package must be granted to the user.
Flashback Transaction Backout: 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