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.
Explanation:
Oracle Database Advanced Application Developer’s Guide 11g, Using Oracle
Flashback Technology
correct answers are CD.
http://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS610
Enable supplemental logging is prerequisites for flashback transaction query feature. So it may not necessary for performing a flashback transaction? I’m not very sure
C, D
Following prerequisites must be met to perform a Flashback Transaction on an Oracle Database 12c database:
– The database must be in ARCHIVELOG mode
– Supplemental logging must be enabled in the database using ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
– A supplemental log data primary key should be created using the statement ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
– The user performing the Flashback Transaction must have the SELECT ANY TRANSACTION privilege
– The user should have the EXECUTE privilege on DBMS_FLASHBACK
– The user should also have appropriate DML privileges on the tables (such as INSERT/UPDATE/DELETE)
So the correct answer should be C and D.
C D
C and D