Which two are prerequisites for performing a flashback transaction? (Choose two.)
Which two are prerequisites for performing a flashback transaction? (Choose two.)
To perform a flashback transaction, the user must have the EXECUTE privilege on the DBMS_FLASHBACK package to operate the flashback features, and supplemental logging must be enabled to ensure all necessary information for the transaction is logged. These are essential prerequisites for using the Flashback Transaction functionality in Oracle databases.
C & D. Oracle 12C Study Guide – Biju Thomas Using Flashback Transaction You can use the Flashback Transaction technology to undo a transaction and its dependent transactions. The DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure is used to accomplish this task. You must meet the following prerequisites 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). Using EM Cloud Control, you can perform the Flashback Transaction. Choose Transactions from the Backup and Recovery menu under Availability.
correct answers are CD. https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS611
I think that A have to be a MUST. AC in my opinion.
Should be A and C
A is not correct, This question is related to flashbacking a transaction..
C y D: To allow access to the features in the DBMS_FLASHBACK package, grant the EXECUTE privilege on DBMS_FLASHBACK. https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS613
You can use the Flashback Transaction technology to undo a transaction and its dependent transactions. The DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure is used to accomplish this task.