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.
B, C and D are correct:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS610
-Enable supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
-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;
-For DBMS_FLASHBACK Package
To allow access to the features in the DBMS_FLASHBACK package, grant the EXECUTE privilege on DBMS_FLASHBACK.