Which is possible reason for this?

You are administering 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.
The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
Which is possible reason for this?
A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
B. The query is unable to place data blocks in the UNDO tablespace
C. The flashback data archive is not enabled for the table on which the query is issued.
D. There is not enough space in Fast Recovery Area.
E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.