【CUUG内部资料】OCP最新考试题库-1Z0-062(1)

【CUUG内部资料】OCP最新考试题库-1Z0-062(1)序：OCP认证是Oracle的一个中级认证，对于升职加薪跳槽都有很大的帮助，但是想考OCP证书其实有一定的难度，比如考试题的内容全部都是英文题、考题的内容会有稍微修改、考题的答案顺序并不固定、不定时的出现新考题等。。。这些都增加了考试的难度，所以我们收集了一些考试题并进行了讲解，这部分内容是关于12c-062的考试解析，希望对广大考生有帮助。QUESTION1Examinetheparametersforyourdatabaseinstance:NAMETYPEVALUE------------------------------------------------------------------------------------undo_managementstringAUTOundo_retentioninteger1200undo_tablespacestringUNDOTBS1Youexecutethefollowingcommand:SQLALTERTABLESPACEundotbs1RETENTIONNOGUARANTEE;Whichstatementistrueinthisscenario?A.Undodataiswrittentoflashbacklogsafter1200seconds.B.Inactiveundodataisretainedfor1200secondsevenifsubsequenttransactionsfailduetolackofspaceintheundotablespace.C.YoucanperformaFlashbackDatabaseoperationonlywithinthedurationof1200seconds.D.Anattemptismadetokeepinactiveundofor1200secondsbuttransactionsmayoverwritetheundobeforethattimehaselapsed.CorrectAnswer:DSection:(none)Explanation验证过QUESTION2AuserestablishesaconnectiontoadatabaseinstancebyusinganOracleNetconnection.Youwanttoensurethefollowing:1.Theuseraccountmustbelockedafterfiveunsuccessfulloginattempts.2.Datareadpersessionmustbelimitedfortheuser.3-Theusercannothavemorethanthreesimultaneoussessions.4.Theusermusthaveamaximumof10minutessessionidletimebeforebeingloggedoffautomatically.Howwouldyouaccomplishthis?A.bygrantingasecureapplicationroletotheuserB.byimplementingDatabaseResourceManagerC.byusingOracleLabelSecurityoptionsD.byassigningaprofiletotheuserCorrectAnswer:D【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481Section:(none)Explanation验证过QUESTION3AsauseroftheORCLdatabase,youestablishadatabaselinktotheremoteHQdatabasesuchthatallusersintheORCLdatabasemayaccesstablesonlyfromtheSCOTTschemaintheHQdatabase.SCOTT'spasswordisTIGER.TheservicemaneHQisusedtoconnecttotheremoteHQdatabase.Whichcommandwouldyouexecutetocreatethedatabaselink?A.CREATEDATABASELINKHQUSING'HQ';B.CREATEDATABASELINKHQCONNECTTOCXJRRENT_USERUSINGHQ'SC.CREATEPUBLICDATABASELINKHQCONNECTTOscottIDENTIFIEDBYtigerUSING'HQ';D.CREATEDATABASELINKHQCONNECTTOscottIDENTIFIEDBYtigerUSING'HQ';CorrectAnswer:CSection:(none)Explanation验证过QUESTION4Whathappensifamaintenancewindowclosesbeforeajobthatcollectsoptimizerstatisticscompletes?A.Thejobisterminatedandthegatheredstatisticsarenotsaved.B.Thejobisterminatedbutthegatheredstatisticsarenotpublished.C.Thejobcontinuestorununtilallstatisticsaregathered.D.Thejobisterminatedandstatisticsfortheremainingobjectsarecollectedthenexttimethemaintenancewindowopens.CorrectAnswer:DSection:(none)Explanation在数据库一直打开的情况下，GATHER_STATS_JOB会伴随维护窗口一起被启动，默认情况下如果到维护窗口关闭该JOB仍未结束则将被终止(这取决于该JOB的属性stop_on_window_close)，剩下的有待收集信息的对象将在下一个维护窗口中得到处理；如果数据库一直处于关闭的状态，并在某维护窗口的时间范围内该DB被打开，那么相应的维护窗口会被立即激活(ACTIVE)，同时GATHER_STATS_JOB自动作业也会被启动，但该自动作业仅会在一个窗口中自动运行一次。【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481QUESTION5YouplantocreateadatabasebyusingtheDatabaseConfigurationAssistant(DBCA),withthefollowingspecifications:Applicationswillconnecttothedatabaseviaamiddletier.Thenumberofconcurrentuserconnectionswillbehigh.Thedatabasewillhavemixedworkload,withtheexecutionofcomplexBIqueriesscheduledatnight.WhichDBCAoptionmustyouchoosetocreatethedatabase?A.aGeneralPurposedatabasetemplatewithdefaultmemoryallocationB.aDataWarehousedatabasetemplate,withthededicatedservermodeoptionandAMMenabledC.aGeneralPurposedatabasetemplate,withthesharedservermodeoptionandAutomaticMemoryManagement(AMM)enabledD.adefaultdatabaseconfigurationCorrectAnswer:CSection:(none)ExplanationExplanation/Reference:QUESTION6WhichtwostatementsaretrueaboutthelogicalstoragestructureofanOracledatabase?A.Anextentcontainsdatablocksthatarealwaysphysicallycontiguousondisk.B.Anextentcanspanmultiplesegments,C.Eachdatablockalwayscorrespondstooneoperatingsystemblock.D.Itispossibletohavetablespacesofdifferentblocksizes.E.AdatablockisthesmallestunitofI/Oindatafiles.CorrectAnswer:DEQUESTION7Whichtwostatementscorrectlydescribetherelationshipbetweendatafilesandlogicaldatabasestructures?A.Asegmentcannotspandatafiles.B.Adatafilecanbelongtoonlyonetablespace.C.Anextentcannotspandatafiles.D.ThesizeofanOracledatablockinadatafileshouldbethesameasthesizeofanOSblock.CorrectAnswer:BCSection:(none)【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481【CUUG内部资料】OCP最新考试题库-1Z0-062OCP考试交流3群：1015267481QUESTION8WhichstatementistrueabouttheLogWriterprocess?A.Itwriteswhenitreceivesasignalfromthecheckpointprocess(CKPT).B.Itwritesconcurrentlytoallmembersofmultiplexedredologgroups.C.ItwritesaftertheDatabaseWriterprocesswritesdirtybufferstodisk.D.Itwriteswhenausercommitsatransaction.CorrectAnswer:DSection:(none)ExplanationExplanation/Reference:QUESTION9TheORCLdatabaseisconfiguredtosuppo