Oracle 11G OCP 1Z0-053 69

（69）The EMP table exists in your schema.You want to execute the following query:

SELECT ename,sal FROM emp AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL'6'MINUTE) WHERE ename='ALLEN';

What are the minimum requirements for the statement to execute successfully?(Choose all that apply)

A. ARCHIVELOG mode must be enabled

B. Row Movement must be enabled for the table

C. FLASHBACK must be set to ON for the database

D. The UNDO_MANAGEMENT parameter must be set to AUTO

E. The UNDO_RETENTION parameter must be set appropriately

答案：（D、E）

解析：

此題考查閃回查詢，因為閃回查詢是基於undo資料的，所以只要保證閃回查詢的那個時間點有undo資料就能夠查詢成功

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1251547/，如需轉載，請註明出處，否則將追究法律責任。