Which configuration should you use to accomplish this task?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *