ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

28 / 190

Question 28:

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.