随笔分类 - Oracle Certification
摘要:121.Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?A)UsetheCREATEDATABASE..commandt
阅读全文
摘要:71.Yourdatabaseinstanceisstartedusingtheserverparameterfile(SPFILE).Controlfilesaremultiplexedandstoredondifferentdisks.Becauseofadiskfailure,youlostoneofthesecontrolfiles.Youreplacedthedamageddisk.Whatisthecorrectsequenceofstepsthatyouwouldfollowtorecoverthecontrolfile?1.shutdowntheinstance,ifnotal
阅读全文
摘要:31.WhichtwostatementsaretrueregardingthedatabaseinARCHIVELOGmode?(Choosetwo.)A)Youhavetoshutdownthedatabasetoperformthebackups.B)Archivinginformationiswrittentothedatafilesandredologfiles.C)Youcanperformcompletedatabasebackupswithoutclosingthedatabase.D)Onlineredologfileshavetobemultiplexedbeforeput
阅读全文
摘要:声明:对于答案的相关的说明,是个人对Oracle的理解。1.Becauseofapoweroutage,instancefailurehasoccurred.Fromwhatpointintheredologdoesrecoverybeginandwheredoesitend?A.CurrentredologandinactiveredologB.CheckpointpositiontoendofredologC.BeginningofredologtoendofredologD.AllredologsbeforethepointoflastcommitE.Beginningofredolog
阅读全文