Your database supports an online transaction processing (OLTP) workload in which one of
the applications creates a temporary table for a session and performs transactions on it. This
consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?
A.
Enable temporary undo for the database.
B.
Enable undo retention guarantee.
C.
Increase the size of the redo log buffer.
D.
Enable Automatic Memory Management (AMM).
E.
Increase the size of the temporary tablespace.
Answer should be A and E.
http://docs.oracle.com/database/121/ADMIN/undo.htm#CEGJGIAE
AE
Im not sure.
A confirm. It’s 12C new feature.
http://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN13741
B – wrong cuz this wud make matters worse
C – wrong cuz not related to the issue of UNDO or TEMP
D – wrong cuz not related to the issue of UNDO or TEMP
Hence A & E
AE
https://docs.oracle.com/cd/E57425_01/121/ADMIN/undo.htm#CEGJGIAE
A,E
http://karandba.blogspot.in/2014/05/temporary-undo-in-12c.html
Definitely A & E.
Why E?
AE