ITPub博客

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

Oracle 11G OCP 1Z0-053 378

原创 Oracle 作者:LuiseDalian 时间:2014-09-29 07:41:22 0 删除 编辑
(378)In order to perform Flashback Transaction Query operations,which of these steps are required?(Choose all that apply.)

A. Ensure that database is running with version 10.1 compatibility.

B. Enable Flashback Logging.

C. Enable Supplemental Logging.

D. Ensure that the database is running with version 10.0 compatibility.

E. Ensure that the database is in ARCHIVELOG mode

答案:(C、D)

解析:

《Advanced Application Developer's Guide》 12.2.2

为了闪回事务查询,要求:

1. COMPATIBLE >= 10.0

2. 开启补充日志:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

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

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

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6043715