分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
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.
UNDO_TABLESPACE | Optional, and valid only in automatic undo management mode. Specifies the name of an undo tablespace. Use only when the database has multiple undo tablespaces and you want to direct the database instance to use a particular undo tablespace. |
Creating an Undo Tablespace
Although Database Configuration Assistant (DBCA) automatically creates an undo tablespace for new installations of Oracle Database Release 11g, there may be occasions when you want to manually create an undo tablespace.
There are two methods of creating an undo tablespace. The first method creates the undo tablespace when theCREATE DATABASE
statement is issued. This occurs when you are creating a new database, and the instance is started in automatic undo management mode (UNDO_MANAGEMENT = AUTO
). The second method is used with an existing database. It uses theCREATE UNDO TABLESPACE
statement.
You cannot create database objects in an undo tablespace. It is reserved for system-managed undo data.