多项选择题
Which two statements are true regarding undo tablespaces（）
A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C.Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
D.An 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.
相关考题
-
多项选择题
Whichthreeoperationsrequireundodata（）
A.committing a transaction
B.flashing back a transaction
C.recovering a failed transaction
D.running a read-consistent query
E.changing a tablespace status from READ ONLY to READ WRITE -
多项选择题
Whichtwostatementscorrectlydescribetherelationbetweenadatafileandthelogicaldatabasestructures（）
A.An extent cannot spread across data files.
B.A segment cannot spread across data files.
C.A data file can belong to only one tablespace.
D.A data file can have only one segment created in it.
E.A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks. -
单项选择题
ote the following structures in your database server： 1：Extents 2：OS Blocks 3：Tablespace 4：Segments 5：Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）
A.2， 5， 1， 4， 3
B.1， 2， 3， 4， 5
C.5， 2， 1， 3， 4
D.2， 1， 5， 4， 3
