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

622.You need to maintain a record of all transactions on some tables for at least three years.

Automatic undo management is enabled for the database.

What must you do accomplish this task?

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

Answer: D

答案解析：

题意是在一些表保存最近三年的所有事务的记录，可以用闪回数据归档实现。

参考：http://blog.csdn.net/rlhua/article/details/12221269

http://blog.csdn.net/rlhua/article/details/12222819