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 enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately

多项选择题

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

OCP 11G认证考试