多项选择题
A.Execute the ALTER DATABASE ARCHIVELOG statement
B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasbeenconfiguredwiththreeredologsgroups，andtherehavebeenfivelogswitches.Youlostonenon-system-criticaldatafilefromyourdatabase.Whichmethodwouldyouusetorecoverthedatafile？（）
单项选择题 YourbossatSupportcenter.cnwantsyoutoclarifyOracle10g.Whichconditioninyourdatabaseforcesyoutoperformonlyconsistentbackups？（）
多项选择题 You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）