Oracle
1Z0-062 · Question #356
1Z0-062 Question #356: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #356. The question stem and answer options stay visible for context.
Managing Undo Data
Question
One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. UNDO_RETENTION is 12 minutes User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes: ORA-01555: snapshot too old Which three factors taken separately or in some combination might be the cause? (Choose three.)
Options
- AAn update was made to the SALES table after the query began
- BAn update to the SALES table was committed after the query began
- CA committed delete to the SALES table was made more than 12 minutes before the query began
- DAn uncommitted update to the SALES table was made more than 12 minutes before the query
- EA committed update to the SALES table was made more than 12 minutes before the query began
- FAn uncommitted delete to the SALES table was made more than 12 minutes before the query
- GAn update was made to the SALES table before the query began
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
#ORA-01555#snapshot too old#UNDO tablespace#UNDO_RETENTION