【OCP-062】1Z0-062最新考试题库解析-第5次课

《【OCP-062】1Z0-062最新考试题库解析-第5次课》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、【CUUG内部资料】OCP讨论群：1015267481【OCP-062】1Z0-062最新考试题库解析-第1次课序：OCP11g认证即将结束，12c已经越来越热，考试共分为3个科目：071、062、063，071的题库解析已经上传，这次整理的是062的考试题，虽然考题多变、不断的增加新题，但有了下面的这些考题，相信会对广大考生有帮助作用，顺利通过OCP考试。QUESTION61Youcreateanewpluggabledatabase,HR_PDB,fromtheseeddatabase.Whi

2、chthreetablespacesarecreatedbydefaultinHR_PDB?A.SYSTEMB.SYSAUXC.EXAMPLED.UNDOE.TEMPF.USERSCorrectAnswer:ABESection:(none)ExplanationExplanation/Reference:*APDBwouldhaveitsSYSTEM,SYSAUX,TEMPtablespaces.Itcanalsocontainsotherusercreatedtablespacesinit.*

3、*OracleDatabasecreatesboththeSYSTEMandSYSAUXtablespacesaspartofeverydatabase.*tablespace_datafile_clausesUsetheseclausestospecifyattributesforalldatafilescomprisingtheSYSTEMandSYSAUXtablespacesintheseedPDB.Incorrect:NotD:aPDBcannothaveanundotablespace

4、.Instead,itusestheundotablespacebelongingtotheCDB.QUESTION62WhichtwostatementsaretrueaboutvariableextentsizesupportforlargeASMfiles?A.ThemetadatausedtotrackextentsinSGAisreduced.B.RebalanceoperationsarecompletedfasterthanwithafixedextentsizeC.AnASMIns

5、tanceautomaticallyallocatesanappropriateextentsize.D.Resyncoperationsarecompletedfasterwhenadiskcomesonlineafterbeingtakenoffline.E.Performanceimprovesinastretchclusterconfigurationbyreadingfromalocalcopyofanextent.CorrectAnswer:AC【CUUG内部资料】OCP讨论群：101

6、5267481Section:(none)ExplanationExplanation/Reference:A:VariablesizeextentsenablesupportforlargerASMdatafiles,reduceSGAmemoryrequirementsforverylargedatabases(A),andimproveperformanceforfilecreateandopenoperations.C:Youdon'thavetoworryaboutthesizes;th

7、eASMinstanceautomaticallyallocatestheappropriateextentsize.QUESTION63YouexecutedaDROPUSERCASCADEonanOracle11grelease1databaseandimmediatelyrealizedthatyouforgottocopytheOCA.EXAM_RESULTStabletotheOCPschema.TheRECYCLE_BINenabledbeforetheDROPUSERwasexecu

8、tedandtheOCPuserhasbeengrantedtheFLASHBACKANYTABLEsystemprivilege.WhatisthequickestwaytorecoverthecontentsoftheOCA.EXAM_RESULTStabletotheOCPschema?A.ExecuteFLASHBACKTABLEOCA.EXAM_RESULTSTOBEFOREDROPRENAMETOOCP.EXAM_RESULTS;connectedasSYSTEM.B.