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.)
A. An update was made to the SALES table after the query began
B. An update to the SALES table was committed after the query began
C. A committed delete to the SALES table was made more than 12 minutes before the query began
D. An uncommitted update to the SALES table was made more than 12 minutes before the query began
E. A committed update to the SALES table was made more than 12 minutes before the query began
F. An uncommitted delete to the SALES table was made more than 12 minutes before the query began
G. An update was made to the SALES table before the query began
|
Download Printable PDF. VALID exam to help you PASS. |
 |