OCP-1Z0-053-200题-100题-69

QUESTION 100

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 statementto 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

Answer: DE

同69题：http://blog.youkuaiyun.com/rlhua/article/details/14108089

Explanation/Reference:

Section: SQL, PL/SQL, Packages, Functions, Jobs & Views