问题:
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.
● 参考解析
A答案:可以有一个或多个undo表空间,A答案正确。
sys@TEST0924> select TABLESPACE_NAME,CONTENTS from dba_tablespaces; TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO
EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected.
B答案:UNDO_TABLESPACE只能用于自动undo段模式,B答案错误