A.the alert.log fileB.the DBA_ALERTS viewC.the Database……

多项选择题YourequiretheOracleservertomanagetheundosegmentsandspaceamongvariousactivesessionsautomatically.Youcreatedanundotablespace，UNDO_TBS1，inyourdatabase.Whichtwoadditionalstepswouldyouperformtoachievethis？（）

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.

单项选择题WhatistheimplicationofsettingtheinitializationparameterFAST_START_MTTR_TARGETto0inyourdatabase？（）

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.

单项选择题YouhavetoshutdownthedatabaseinstancewiththeABORToptionbecauseofahardwarefailure.Whichstatementistrueaboutthesubsequentopeningofthedatabase？（）

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.

多项选择题WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）

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；

多项选择题View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D：  oracle product 10.2.0 oradata oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

A.The tablespace has two data files.
B.An error is reported and tablespace creation fails.
C.Data files are created with names generated by the instance.
D.The tablespace can be extended without specifying the data file.
E.Data files belonging to the USERS tablespace cannot be renamed.