Oracle Database 12c: Installation and Administration — Question 243

You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

Answer options

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database.
• C. Create a Flashback Data Archive in the tablespace where the tables are stored.
• D. Create a Flashback Data Archive in any suitable tablespace.
• E. Enable Flashback Data Archiving for the tables that require tracking.

Correct answer: D, E

Explanation

The correct actions to track the transactions are to create a Flashback Data Archive in any suitable tablespace (D) and to enable Flashback Data Archiving for the tables that need monitoring (E). Options A, B, and C do not provide a solution for retaining transaction data for the required duration.