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?()
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
出自:Oracle认证