2022OracleOCP认证考试题库OracleOCP认证考试题库Oracle开发的关系数据库产品因性能卓越而著名，Oracle数据库产品为财宝排行榜上的前1000家公司所采纳，很多大型网站也选用了Oracle系统，是世界最好的数据库产品。以下是我整理的关于OracleOCP认证考试题库，希望大家仔细阅读!QUESTION1Younoticethattheperformanceofthedatabasehas第1页共16页degradedbecauseoffrequentcheckpoints.Whichtwoactionsresolvetheissue?(Choosetwo.)A.DisableautomaticcheckpointtuningB.CheckthesizeoftheredologfilesizeandincreasethesizeifitissmallC.SettheFAST_START_MTTR_TARGETparameteraspertheadvicegivenbytheMTTRAdvisorD.Decreasethenumberofredologmembersiftherearemorethanoneredologmembersavailableineachredolog第2页共16页groupCorrectAnswer:BCExplanation/Reference:检查点进程:Thecheckpointprocess(CKPT)updatesthecontrolfileanddatafileheaderswithcheckpointinformationandsignalsDBWntowriteblockstodisk.Checkpointinformationincludesthecheckpointposition,SCN,locationinonlineredologtobeginrecovery,andsoon.CKPTdoesnotwrite第3页共16页datablockstodatafilesorredoblockstoonlineredologfiles.检查点作用:(1)定期促进DBWn进程把内存的脏块写回到数据文件,数据库故障时不会丢数据(2)削减实例复原的时间(3)确保全部已提交的数据在一样性关闭期间会被写入数据文件实例复原时间:指的是将数据文件的最终一个检查点(检查点位置)推动到限制文第4页共16页件中记录的最新SCN所需的.时间.管理员可以通过设置MTTR目标以及调整重做日志组的大小来限制该时间.MTTR:MeanTimeToRepair,即平均修复时间.是指可修复产品的平均修复时间,就是从出现故障到修复中间的这段时间.MTTR越短表示易复原性越好.在数据库中可以通过设置参数FAST_START_MTTR_TARGET(单位为秒),限制数据库对单个实例执行崩溃复原所花费的时间.FAST_START_MTTR_TARGE=非0值,启用快速启动检查点功能,自第5页共16页动限制发检查点速度.FAST_START_MTTR_TARGE=0,禁用快速启动检查点功能.假如重做日志文件的size太小,会频繁切换日志,即会频繁发生检查点,故可以增大重做日志文件的size削减检查点发生频率.FAST_START_MTTR_TARGET假如设置的太小,为了要限制数据库单实例的实例复原时间，则必需频繁发生检查点,确保内存中已修改的数据块能够定期写入到磁盘,故可以运用MTTRAdvisor来设置举荐的值.QUESTION2第6页共16页Identifythememorycomponentfromwhichmemorymaybeallocatedfor:Sessionmemoryforthesharedserver,BuffersforI/OslavesOracleDatabaseRecoveryManager(RMAN)backupandrestoreoperationsA.LargePoolB.RedoLogBufferC.DatabaseBufferCacheD.ProgramGlobalArea(PGA)CorrectAnswer:A第7页共16页Explanation/Reference:LargePoolThelargepoolisanoptionalmemoryareaintendedformemoryallocationsthatarelargerthanisappropriateforthesharedpool.Thelargepoolcanprovidelargememoryallocationsforthefollowing:UGAforthesharedserverandtheOracleXAinterface(usedwheretransactionsinteractwithmultipledatabases)Messagebuffersusedintheparallelexecutionof第8页共16页statementsBuffersforRecoveryManager(RMAN)I/OslavesByallocatingsessionmemoryfromthelargepoolforsharedSQL,thedatabaseavoidsperformanceoverheadcausedbyshrinkingthesharedSQLcache.ByallocatingmemoryinlargebuffersforRMANoperations,I/Oserverprocesses,andparallelbuffers,thelargepoolcansatisfylargememoryrequestsbetterthanthesharedpool.QUESTION3第9页共16页YouexecutedthefollowingcommandtocreateatablespacecalledSALES_DATA:SQL>CREATETABLESPACEsales_dataDATAFILESIZE100MSEGMENTSPACEMANAGEMENTAUTO;WhichtwostatementsaretrueabouttheSALES_DATAtablespace?(Choosetwo)A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.第10页共16页B.Thesegmentsareautomaticallyshrunkwhenthecontents...
