Which statement is correct regarding undo management?
A. The database can have more than one undo tablespaces
B. The undo data must be purged manually when the transaction is over
C. The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF
D. Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL
Answer:A
Which statement is correct regarding undo management?
A. The database can have more than one undo tablespaces B. The undo data must be purged manually when the transaction is over C. The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF D. Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL
Explanation: Oracle provides an automatic undo management, for managing undo information and space. With automatic undo management, the database manages undo segments in an undo table-space.