多选题
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答案错误
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答案错误
相似试题
Which two statements are true about Oracle Real Applications Insight ？（）
多选题查看答案
Which two statements are correct regarding the Oracle Flashback Drop feature？ （）
多选题查看答案
Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）
多选题查看答案
Which two statements are true？（）
多选题查看答案
Which two operations require undo data？（）
多选题查看答案
Which two statements are true about alerts（）
多选题查看答案
Which two triggers are mouse movement triggers?（）
多选题查看答案
Which two statements are true regarding listeners（）
多选题查看答案
Which two statements are true regarding views?（）
多选题查看答案
Which two statements are true about checkpointing（）
多选题查看答案