多选题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 successf
题目
多选题
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
相似考题
参考答案和解析
正确答案：
B,C
解析：
暂无解析