There is a business requirement to track and store all transactions for at least three years for a few
tables in the database. Automatic undo management is enabled in the database. Which
configuration should you use to accomplish this task?
A.
Enable Flashback Data Archive for the tables
B.
Enable supplemental logging for the database
C.
Specify undo retention guarantee for the database
D.
Create Flashback Data Archive on the tablespace on which the tables are stored
E.
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an
undo tablespace for that size