多项选择题

You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

A.Set the UNDO_RETENTION parameter to 900 or more.
B.Create an initial undo segment in the undo tablespace.
C.Enable the retention guarantee for the undo tablespace.
D.Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E.Set the UNDO_MANAGEMENT initialization parameter to AUTO.

点击查看答案

上一题目录下一题

相关考题

单项选择题

What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）

A.MTTR Advisor would be disabled.
B.Redo Log Advisor would be disabled.
C.Automatic tuning of checkpoint would be disabled.
D.Checkpoint information would not be written to the alert log file.

单项选择题

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

A.The database would open normally.
B.The database would not open， and it would stop at mount stage.
C.The database would open after automatically performing instance recovery.
D.The database would not open， and you have to perform database recovery to open it.

多项选择题

Which two operations can be flashed back using the Flashback technology？（）

A.DROP USER SMITH；
B.DROP TABLE EMPLOYEES；
C.DROP TABLESPACE USERS；
D.ALTER TABLE SALES_REP DROP PARTITION P1；
E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；