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

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

转载于:http://blog.itpub.net/17013648/viewspace-1284284/