Oracle 11G OCP 1Z0-053 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

答案：（D）

解析：

閃回資料歸檔的步驟是先建立閃迴歸檔的表空間，如何再啟用表的閃迴歸檔特性，預設情況下，是禁用表的閃迴歸檔特性

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1329176/，如需轉載，請註明出處，否則將追究法律責任。