Oracle
1Z0-034 · Question #93
1Z0-034 Question #93: Real Exam Question with Answer & Explanation
The correct answer is D. The UNDO_MANAGEMENT parameter must be set to AUTO E. The UNDO_RETENTION parameter must be set appropriately. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.