OCP-1Z0-053-V12.02-106题

106.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.

Answer: A

答案解析：

参考：闪回数据归档概述：http://blog.csdn.net/rlhua/article/details/12221269

闪回数据归档实验测试：http://blog.csdn.net/rlhua/article/details/12222819

需要将表启用闪回数据归档。