单项选择题
You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()
A.Shut down the instance, copy the control file to the third location and open the database.
B.Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
C.Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.
D.Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
E.Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.
相关考题
-
单项选择题
ThedatafilebelongingtotheSYSTEMtablespaceiscorruptedandnobackupofthefileisavailable.Howdoyourecoverthedatafile?()
A.The data file cannot be recovered.
B.The date file can be restored from theSYSTEMauto backup.
C.Take thetablespaceoffline,drop,kand re-create it.
D.Recovery Manager (RMAN) is used to recover the data file.
E.The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file. -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective,whichcomponentwouldyouconfigureoneachdatabaseserver?()
A.Database Control
B.Management Server
C.Management Repository
D.Application Server Control
E.Oracle Management Agent -
多项选择题
YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhichtwostepsareperformedthefirsttimeanyUPDATEstatementisissuedaftertheinstanceisstarted?()
A.Creating the parse tree of the statement
B.Writing the modified data blocks to the data files
C.Writing the modified data to the archived redo log files
D.Updating the control file to indicate the most recent checkpoint
E.Updating the data file header to indicate the most recent checkpoint
F.Reading the blocks to database buffer cache if they are not already there
