26.Which two statements are true regarding undo tablespaces? (Choose two.)
A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management.
C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
D.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
答案:AC
解析:
A:肯定是对的,可以创建多个,但是同时只能写一个
undo_management : auto 说明是自动管理的,manual说明是手动管理的,他不是一个动态参数,需要在初始化设置文件中配置,并且修改后必须重启
undo_tablespace : 用的哪个还原表空间 --open状态下可以动态进行修改
如果是自动管理那么会使用上面的undo,如果不是自动管理那么不会使用undo而是使用系统表空间的system段,因此D是错误,当设置为手动的话,UNDO_TABLESPACE不生效因此B也是错的
C: 正确
A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management.
C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
D.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
答案:AC
解析:
A:肯定是对的,可以创建多个,但是同时只能写一个
undo_management : auto 说明是自动管理的,manual说明是手动管理的,他不是一个动态参数,需要在初始化设置文件中配置,并且修改后必须重启
undo_tablespace : 用的哪个还原表空间 --open状态下可以动态进行修改
如果是自动管理那么会使用上面的undo,如果不是自动管理那么不会使用undo而是使用系统表空间的system段,因此D是错误,当设置为手动的话,UNDO_TABLESPACE不生效因此B也是错的
C: 正确