单项选择题
You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）
A.The instance would normally abort.
B.The instance would not be affected.
C.The instance would be invalid， so would have to be aborted.
D.The instance would remain open， but the LGWR process would fail.
E.The instance would remain open and would automatically create the missing file
相关考题
-
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Inyourorganization，youhavefourdatabases，SupportCenterDB01，SupportCenterDB02，SupportCenterDB03，andSupportCenterDB04，whicharelocatedinBerlin，Frankfurt，Rammstein，andMunichrespectively，andwhichwerecreatedusingDatabaseConfigurationAssistant（DBCA）.Youwanttoperformadministrativetasksonthesedatabasesthatincludestartupandshutdown，takingregularbackups，andsoon，fromFrankfurtusingOracletools.WhichOraclefilewouldyouenabletoperformthistask？（）
A.Control file
B.Password file
C.Parameter file
D.Online redo log file
E.Listener controller file
F.Server parameter file -
多项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Youwanttocreateyourdatabasewiththeautomaticundomanagementfeatureenable.Whichtwotasksmustyouperformtoachievethis？（）
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.
