Users notify you that their application is failing every time they try to add new records.
Because of poor application design, the actual ORA error message is unavailable.
What might be the problem? (Choose the best answers.)
A.
The application user has exceeded their undo quota.
B.
The FLASHBACK GUARANTEE option is set on the undo tablespace.
C.
The table is currently being queried by a Flashback Transaction Query operation.
D.
The table is currently being queried by a Flashback Versions Query operation.
E.
The RETENTION GUARANTEE option is set on the undo tablespace.
D is also correct
This question is from the book
http://www.amazon.com/Oracle-Database-All-Guide-CD-ROM/dp/0071629181
Here is the answer it gives … (This is for information purposes, this is not necessarily my opinion)
A, E. The likely causes are that the RETENTION GUARANTEE option has been set on the undo tablespace and there are no expired transactions to remove to make room for new transactions, or that the user has exceeded the undo quota that has been set by the database resource manager. FLASHBACK GUARANTEE is not a valid option, so option B is incorrect. Flashback queries would not interfere with transactions entering the system, so options C and D are incorrect.
Hey I just though of a new possible question …
You have a problem with your database, what could the solution be?
(any opinions are welcome? marks out of 10?)