QUESTION 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
Correct Answer: DE
EMP表中存在的模式。你要执行以下查询:
SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6’ MINUTE) WHERE ename = ‘ALLEN’;
成功执行的语句的最低要求是什么?
D. The UNDO_MANAGEMENT 参数必须设置为自动
E. The UNDO_RETENTION 参数必须设置适当