OCP-1Z0-043题库+

Exam:1Z0-043Title:OracleDatabase10g:AdministrationIIVer:11.17.061Z0-043Actualtests.com-ThePowerofKnowingQUESTION1:Youobservethatadatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto,inordertodeterminethatrequiredsizeofthedatabasebuffercache?A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)Answer:AQUESTION2:ExhibitInyourproductiondatabase,thetotalwaitsandthetimewaitedforlogfileparallelwritearesignificantlyhigh.Whileinvestigatingthereason,youfindthattherearethreeredologgroupswithtwomembersineachgroup,andallredologmembersareplacesonasinglephysicaldisk.Whatactionwouldyoutaketominimizethewaits?A.startthelogwriterslaveprocessesB.increasethenumberofredologfilesC.increasethesizeoftheredologbufferD.placetheredologfilesonthedifferentdisksE.increasethenumberoflogwriterprocessesAnswer:D1Z0-043Actualtests.com-ThePowerofKnowingQUESTION3:Oneofthetablespacesisread-onlyinyourdatabase.Thelossofallcontrolfilesforcedyoutore-createthecontrolfile.Whichoperationdoyouneedtoperformafterre-creatingthecontrolfileandopeningthedatabase?A.dropandre-createtheread-onlytablespacesB.renametheread-onlydatafilestotheircorrectfilenamesC.changethetablespacestatusfromread/writetoread-onlyD.re-createtheread-onlytablespacebecauseitisautomaticallyremovedAnswer:BQUESTION4:Youhavesetsomeoftheinitializationparametersas:DB_BLOCK_SIZE=8KBSGA_MAX_SIZE=2GBSGA_TARGET=0SHARED_POOL_SIZE=120MBDB_CACHE_SIZE=896MBSTREAM_POOL_SIZE=0LARGE_POOL_SIZE=110MBWhichtwostatementsarecorrect?(Choosetwo.)A.YoucannotsetavaluefortheDB_8K_CACHE_SIZEparameter.B.Ifyouincreasethesizeofthelargepoolto120MB,thenthememoryallocatedtothesharedpollwillbereducedto110MB.C.IfthevalueforSGA_TARGETischangedto1GBandSHARED_POOL_SIZEissetto120MB,thenmemorycannotbetakenfromthesharedpool,evenifthesharedpoolhasfreespaceavailable.D.Ifanapplicationattemptstoallocatemorethan120MBfromthesharedpoolandfreespaceisavailableinthebufferpool,thenthefreespacefromthebufferpoolisallocatedtothesharedpool.Answer:A,CQUESTION5:Youareperformingablockmediarecoveryonthetools01.dbfdatafileintheSALESdatabaseusingRMAN.Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)A.YoumustensurethattheSALESdatabaseismountedoropen.B.Youmustrestoreabackupcontrolfiletoperformablockmediarecovery.C.Youmusttakethetools01.dbfdatafileofflinebeforeyoustartablockmediarecovery.D.YoumustputthedatabaseinNOARCHIVELOGmodetoperformablockmediarecovery.E.Youcanperformonlyacompletemediarecoveryofindividualblocks,point-in-timerecoveryofindividualdatablocksisnotsupported.Answer:A,E1Z0-043Actualtests.com-ThePowerofKnowingQUESTION6:ExhibitYouexecutedthefollowingcommandtoperformabackupoftheUSERStablespace:RMANBACKUPTABLESPACEUSERS;Whichtypeofbackupwouldthiscommandperform?A.backupsetB.imagecopyC.incrementalbackupD.None;theuserreceivesonerrorindicatingthatthebackupmustbespecified.Answer:AQUESTION7:Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?A.importthedatabasefromthelastexportB.restoreallthemembersinthegroupfromthelastbackupC.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroupD.restoreallthedatabasefilesfromthebackupandthenperformacompleterecoveryE.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecoveryAnswer:CQUESTION8:YouareusingOracleDatabase10g.Whichstatementregardinganincompleterecoveryistrue?A.Youdonotneedtorestoreallthedatafiles.B.YoudonotneedtoopenthedatabasewiththeRESETLOGSoperationC.YoudonotneedtoperformafullbackupaftertheRESETLOGSoperation.D.Youdonotneedtorecoverallthedatafilestothesamesystemchangenumber(SCN).Answer:CQUESTION9:Exhibit1Z0-043Actualtests.com-ThePowerofKnowingViewtheExhibitandexaminetheResourceManagersettingsforthegroupsatdifferentlevels.Whichtwoeffectswouldbetheresultofthissetting?(Choosetwo.)A.ThemembersofLOW_GROUPwouldgetmoreprioritythanthoseofOTHER_GROUPS.B.ThemembersofSYS_GROUPwouldgetmostoftheCPUallocationatlevel1.C.ThemembersofLOW_GROUPwouldgetmostoftheCPUallocationbecauseithasCPUallocationattwodifferentlevels.D.ThemembersofLOW_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.E.ThemembersofSYS_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.Answer:A,BQUESTION10:Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication,theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective?(Choosetwo.)A.usetheALTERSYSTEMcommandtochangethetimezoneB.usetheALTERSESSIONcommandtochangethetimezoneC.usetheALTERDATABASEcommandtochangethetimezoneD.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachineE.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachineAnswer:B,DQUESTIO