Exam 1z0-062 topic 1 question 145 discussion

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

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.

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

I think that A have to be a MUST. AC in my opinion.