单项选择题

A.Until last commitB.Until the time you perform recover……

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

A.Until last commit
B.Until the time you perform recovery
C.Until the time the date file got corrupted
D.Until the point where the last transaction begun
E.You cannot recover the SYSTEMtablespaceand must re-create the database.

<上一题目录下一题>

热门试题

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Inyourproductiondatabase，thesizeofDatabaseBufferCacheneedstobeincreasedimmediatelyforthecurrentaswellasfutureinstancesofthedatabase.TheOracleinstancehasbeenconfiguredtoaccommodateanychangesinthesizeofthememorystructures.Atthisisproductiondatabase，youwanttoaccomplishthistaskwithnoimpactontheuser’sconnections.Whichactivitymustyouhavecompletedbeforeaccomplishingthistask？（）

A.You must have started the database instance in restricted mode.
B.You must have started the database instance inNORMALmode.
C.You must have started the database instance with server parameter file.
D.You must have started the database instance but must not have mounted.
E.You must have started the database instance but must not have opened.

多项选择题You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）

A.snmp.ora
B.names.ora
C.spfile.ora
D.sqlnet.ora
E.listener.ora
F.tnsnames.ora

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youstartedtheinstanceusingtheinit.orafile.Youhavetwocontrolfilesandthreeredologgroupsinyourdatabase.Youdecidedtoprotectthedatabaseagainstfailuresbyaddingonemorecontrolfile.Whichfileistheappropriatewaytoperformthistask？（）

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 the SYSTEM auto 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.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective，whichcomponentwouldyouconfigureoneachdatabaseserver？（）

A.Database Control
B.Management Server
C.Management Repository
D.Application Server Control
E.Oracle Management Agent