【多选题】You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps...
A.
Set the UNDO_RETENTION parameter to 900 or more.
B.
Create an initial undo segment in the undo tablespace.
C.
Enable the retention guarantee for the undo tablespace.
D.
Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E.
Set the UNDO_MANAGEMENT initialization parameter to AUTO.
【单选题】The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?()
A.
Undo data becomes obsolete after 1,000 seconds.
B.
Undo data gets refreshed after every 1,000 seconds.
C.
Undo data will be stored permanently after 1,000 seconds.
D.
Committed undo data would be retained for 1,000 seconds if free undo space is available.
E.
Undo data will be retained in the UNDO tablespace for 1,000 seconds,then it gets moved to the TEMPORARY tablespace to provide read consistency.