Oracle 11G OCP 1Z0-053 378

(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

请使用浏览器的分享功能分享到微信等