ITPub博客

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

Oracle 11G OCP 1Z0-053 106

原创 Oracle 作者:LuiseDalian 时间:2014-08-19 07:05:33 0 删除 编辑
(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.

答案:(A)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1253560/ ,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6042563