Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?
A. It contains undo only for uncommitted transactions.
B. It is used for the FLASHBACK TABLE…TO BEFORE DROP operation.
C. It can be recovered while the instance is open in READ WRITE mode.
D. It must be a smallfile tablespace.
E. It is a locally managed tablespace.
D