【多选题】Which two statements are true regarding undo tablespaces? (Choose two.)
A.
An undo tablespace is automatically created if the UNDO TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
B.
Undo segments automatically grow and shrink as needed. acting as circular storage buffer for their assigned transactions
C.
The UNDO TABLESPACE parameter is valid in both automatic and manual undo management
D.
The database can have more than one undo tablespace
【多选题】Which two statements are true regarding undo tablespaces()
A.
The database can have more than one undo tablespace.
B.
The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C.
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
D.
An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
【多选题】Which two statements are true regarding undo tablespaces?(Choose two)
A.
The database can have more than one undo tablespace
B.
The UNDO TABLESPACE parameter is valid in both automatic and manual undo management
C.
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
D.
An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up