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. Specify undo retention guarantee for the database.
C. Enable supplemental logging for the database.
D. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
E. Create Flashback Data Archive on the tablespace on which the tables are stored.
|
Download Printable PDF. VALID exam to help you PASS. |
 |