1Z0-042 oracle数据库认证相关文档 042

Exam:1Z0-042Title:OracleDatabase10g:AdministrationIVer:03-13-081Z0-042Actualtests.com-ThePowerofKnowingQUESTION1:Youexecutedthefollowingcommandtobackupthecontrolfile:ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatdoyoufindinthetracefile?A.ImageofthecontrolfileB.LocationofthecontrolfileC.ContentsofthecontrolfileintextformatD.SQLcommandtore-createthedatabaseE.SQLcommandtore-createthecontrolfileF.ContentsofthecontrolfileinbinaryformatAnswer:EQUESTION2:YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhichtwostepsareperformedthefirsttimeanyUPDATEstatementisissuedaftertheinstanceisstarted?ChoosetwoA.CreatingtheparsetreeofthestatementB.WritingthemodifieddatablockstothedatafilesC.WritingthemodifieddatatothearchivedredologfilesD.UpdatingthecontrolfiletoindicatethemostrecentcheckpointE.UpdatingthedatafileheadertoindicatethemostrecentcheckpointF.ReadingtheblockstodatabasebuffercacheiftheyarenotalreadythereAnswer:C,DQUESTION3:YouworkasadatabaseadministratorforCertkiller.com.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective,whichcomponentwouldyouconfigureoneachdatabaseserver?A.DatabaseControlB.ManagementServerC.ManagementRepositoryD.ApplicationServerControlE.OracleManagementAgent1Z0-042Actualtests.com-ThePowerofKnowingAnswer:EQUESTION4:ThedatafilebelongingtotheSYSTEMtablespaceiscorruptedandnobackupofthefileisavailable.Howdoyourecoverthedatafile?A.Thedatafilecannotberecovered.B.ThedatefilecanberestoredfromtheSYSTEMautobackup.C.Takethetablespaceoffline,drop,kandre-createit.D.RecoveryManager(RMAN)isusedtorecoverthedatafile.E.TheALTERDATABSECREATEDATAFILE..commandisusedtorecoverthedatafile.Answer:AQUESTION5:YouworkasadatabaseadministratorforCertkiller.com.Youstartedtheinstanceusingtheinit.orafile.Youhavetwocontrolfilesandthreeredologgroupsinyourdatabase.Youdecidedtoprotectthedatabaseagainstfailuresbyaddingonemorecontrolfile.Whichfileistheappropriatewaytoperformthistask?A.Shutdowntheinstance,copythecontrolfiletothethirdlocationandopenthedatabase.B.Aborttheinstance,copythecontrolfiletothethirdlocation,modifytheCONTROL_FILESparameterintheinit.orafileandopenthedatabase.C.Copythecontrolfiletothethirdlocation,modifytheCONTROL_FILESparameterintheinit.orafile,restarttheinstanceandopenthedatabase.D.Shutdowntheinstance,copythecontrolfiletothethirdlocation,modifytheCONTROL_FILESparameterintheinit.orafileandopenthedatabase.E.Shutdowntheinstance,startupinthemountstate,copythecontrolfiletothethirdlocation,modifytheCONTROL_FILESparameterininit.oraandopenthedatabase.Answer:DQUESTION6:YouworkasadatabaseadministratorforCertkiller.com.YoufindthatthedatabaseperformancedegradeswhileyoubackuptheCertkillerdatabaseusingRecoveryManager(RMAN).TheCertkillerdatabaseisrunninginsharedservermode.1Z0-042Actualtests.com-ThePowerofKnowingThedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.Whichactionwouldyouconsidertoovercometheperformancedegradation?A.ConfigureJavaPooltocachethejavaobjects.B.ConfigureStreamsPooltoenableparallelprocessing.C.IncreaseSharedPoolsizetocachemorePL/SQLobjects.D.IncreaseDatabaseBufferCachesizetoincreasecachehits.E.ConfigureLargePooltobeusedbyRMANandsharedserver.F.IncreasethetotalSystemGlobalArea(SGA)sizetoincreasememoryhits.Answer:EQUESTION7:YouworkasadatabaseadministratorforCertkiller.com.YoudecidedtomanageclientandserverconnectionsusingLocalNamingmethodinCertkiller.com.Whenyoutrytoconnecttothedatabaseyougetthefollowingerror:ERROR:ORA-12154:TNS:couldnotresolveservicenameWhichnetworkconfigurationfileswouldyoulookintotoresolvethiserror?Choosetwo.A.snmp.oraB.names.oraC.spfile.oraD.sqlnet.oraE.listener.oraF.tnsnames.oraAnswer:D,FQUESTION8:YouworkasadatabaseadministratorforCertkiller.com.Inyourproductiondatabase,thesizeofDatabaseBufferCacheneedstobeincreasedimmediatelyforthecurrentaswellasfutureinstancesofthedatabase.TheOracleinstancehasbeenconfiguredtoaccommodateanychangesinthesizeofthememorystructures.Atthisisproductiondatabase,youwanttoaccomplishthistaskwithnoimpactontheuser'sconnections.Whichactivitymustyouhavecompletedbeforeaccomplishingthistask?A.Youmusthavestartedthedatabaseinstanceinrestrictedmode.B.YoumusthavestartedthedatabaseinstanceinNORMALmode.1Z0-042Actualtests.com-ThePowerofKnowingC.Youmusthavestartedthedatabaseinstancewithserverparameterfile.D.Youmusthavestartedthedatabaseinstancebutmustnothavemounted.E.Youmusthavestartedthedatabaseinstancebutmustnothaveopened.Answer:CQUESTION9:YourCertkiller.comdatabaseisinARCHIVELOGmode.ThedatafilethatbelongstotheSYSTEMtablespacehasbecomecorrupted.Uptowhatpointcanyourecoverthedatabase?A.UntillastcommitB.UntilthetimeyouperformrecoveryC.UntilthetimethedatefilegotcorruptedD.UntilthepointwherethelasttransactionbegunE.YoucannotrecovertheSYSTEMtablespaceandmustre-createthedatabase.Answer:AQUESTION10:YouworkasadatabaseadministratorforCertkiller.com.TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementreg