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)

Question

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)

Accepted Answer

D. The UNDO_MANAGEMENT parameter must be set to AUTO E. The UNDO_RETENTION parameter must be set appropriately

Answer

A. ARCHIVELOG mode must be enabled

Answer

B. Row Movement must be enabled for the table

Answer

C. FLASHBACK must be set to ON for the database

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…

Question

Options

How the community answered

Community Discussion