oracle-ocp-043试题分类汇总

《oracle-ocp-043试题分类汇总》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、性能调优1.Youobservethatadatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwoldyoureferto,inordertodeterminethatrequiredsizeofthedatabasebuffercache?A

2、.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)A发现数据库运行一段时间后性能下降了，调查发现原因是因为buffercache不能装下所有需要的数据块，用个工具确定数据库所需要的buffercache的大小。2.Exhibit--显示所有日志在同一个目录下Inyourproductiondatabase,thetotalwaitsandthetimewaitedforlogfilepa

3、rallelwritearesignificantlyhigh.Whileinvestigatingthereason,youfindthattherearethreeredologgroupswithtwomembersineachgroup,andallredologmembersareplacesonasinglephysicaldisk.Whatactionwouldyoutaketominimizethewaits?A.StartthelogwriterslaveprocessesB.Increasethenumberofredologfi

4、lesC.IncreasethesizeoftheredologbufferD.Placetheredologfilesonthedifferentdisks.E.Increasethenumberoflogwriterprocesses.Answer:D等待并行写日志的时间明显很高。调查发现三个日志文件组，每组由两个成员，都在同一个物理磁盘上。通过什么方法解决问题？--主要是不懂题目意思会出错。24.YouaredesigninganapplicationforCertkiller.comandyouhavebeenaskedtodesignada

5、tabasetabletofacilitatemonthlybillgeneration.Thebillwouldincludedetailsofcustomercalls,listedinchronologicalorder.Whichmethodwouldyoufollowtoachievethisobjectivewithoutincreasingtheoverheadofsortingtherows?A.createahashclustertostorethedataB.createanindexclustertostorethedataC.

6、createapartitionedtabletostorethedataD.createasortedhashclustertostorethedataE.createaheaptablewithrowidtostorethedataAnswer:D27.Inwhichscenarioswouldyourebuildanindex?(Chooseallthatapply.)A.whenyouneedtodisabletheindexusageB.whenyouneedtochangestorageoptionsC.whenyouneedtoenab

7、leindexmonitoringD.whenyouneedtomovetheindextoanothertablespaceAnswer:B,D35.Whiledesigningyourdatabase,youhavecreatedtheEMPLOYEEStableasanindex-organized(IOT).YouwanttocreateabitmapindexontheJOD_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatet

8、hebitmapindex?A.Aprimarykeymusthavebeencreated.B.Amapp