问题

Which two statements&#8194

Which two statements are true regarding undo tablespaces（）

AThe database can have more than one undo tablespace.
BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
DAn 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答案错误

分类：1Z0-052题库

Which&#8194;two&#8194;statements&#8194

Which two statements&#8194