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/，如需轉載，請註明出處，否則將追究法律責任。