多項選擇題

You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

A.Set the UNDO_RETENTION parameter to AUTO.
B.Create an initial undo segment in undotablespace.
C.Set the UNDO_RETENTION parameter to 900 or more
D.Set the initialization parameter UNDO_MANAGEMENT to AUTO
E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

你可能感興趣的試題

單項選擇題

You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：
ERROR at Line 1：
ORA-10635： Invalid segment or tablespace type
What could be the reason？（）

A.The table is partitioned
B.The table name is wrong.
C.It is an index-Organized table （IOT）
D.The table is stored in locally managedtablespace.
E.The table is stored in atablespacewhere segment space is managed manually.

單項選擇題

You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

A.Hot backup
B.Online backup
C.consistent backup
D.incremental backup
E.inconsistent backup

_{<cite id="sjfjm"><option id="sjfjm"></option></cite>}