Question

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

I had been asked this question at a job interview.

Asked question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle

Answer 1

Right answer is (a) The database can have more than one undo tablespaces

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.