Oracle
1Z0-034 · Question #93
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…
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
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)
Options
- AARCHIVELOG mode must be enabled
- BRow Movement must be enabled for the table
- CFLASHBACK must be set to ON for the database
- DThe UNDO_MANAGEMENT parameter must be set to AUTO
- EThe UNDO_RETENTION parameter must be set appropriately
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.