Oracle
1Z0-062 · Question #264
1Z0-062 Question #264: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #264. The question stem and answer options stay visible for context.
Managing Undo Data
Question
You areadministering a database that supports an OLTP workload. The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes. The user SCOTT queries a large table during peak activity. Thequery runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old Which is possible reason for this?
Options
- AThe Oracle server is unable to generate a read-consistent image for a block containing
- BThe query is unable to place data blocks in the UNDO tablespace.
- CThe flashback data archive is not enabled for the table on which the query is issued.
- DThere is not enough space in Fast Recovery Area.
- EThe Oracle server is unable to generate a read-consistent image for a block containing
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.
Topics
#UNDO tablespace#ORA-01555#Undo retention#Read consistency