试题详情
单项选择题 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.

  • A

  • 关注下方微信公众号，在线模考后查看

热门试题