问题

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题库

编辑推荐

当市场利率为12%时，面值为1000元，票面利息率为8%，每年年末.....

产后出血原因中哪项首先考虑用子宫切除的方法止血（）..

表示肿瘤为恶性的是（）。..

水泥生产铁质校正质料中的三氧化二铁的含量大于（）。..

可能发生癌变的疾病是（）..

新史学的特点：..

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

Which two statements&#8194