ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 622

Oracle 11G OCP 1Z0-053 622

原创 Oracle 作者:LuiseDalian 时间:2014-11-12 07:28:23 0 删除 编辑
(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博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1329176/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6040856