You are working as a DBA on the decision support system. 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.