OCP考试052最新考试题库原题-2-20180518

《OCP考试052最新考试题库原题-2-20180518》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、052题库解析最新15道题052-题库解析-2-20180518题库新特点：l更加灵活，题库的顺序与考试时的顺序每场都在变化l更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：www.cuug.com1、.WhichtwoaretrueabouttheArchive(ARCn)processes?❑A)Theyautomaticallydeleteobsoletearchive

2、logstomakespacefornewarchivelogs.❑B)TheyareusedduringInstancerecovery.❑C)Theyarchiveredodirectlyfromtheredologbuffer.❑D)TheyareenabledonlywhenthedatabaseIsInARCHTVELOCmode.❑E)Theycreatearchivelogsaftereverylogswitch. •Answer:DE2、WhichtwoaretrueaboutOptimizerStatistics? ❑A)Theydonotpersista

3、crossInstancerestarts.❑B)TheyareautomaticallyupdatedwhenDDLstatementsexecute.❑C)TheyaregatheredbytheManageabilityMonitor(MMON)backgroundprocess.❑D)TheycanbegatheredbyexecutingthePL/SQLproceduresintheDBMS_STATSpackage.❑E)Theycanbeusedtodeterminetheeventsonwhichadatabaseinstancewaited.❑F)The

4、yprovideInformationtotheOptimizersothatitcandetermineoptimalexecutionplansforSQLstatements.•Answer:DF3、Whichstructurecanspanmultipledatafiles? ❑A)apermanenttablespace❑B)abigfiletablespace❑C)atemporarytablespace ❑D)asegment❑E)anextent•Answer:ACD4、Forwhichrequirementshouldyouconfigureshareds

5、ervers?❑A)accommodatinganincreasingnumberofuserswhorun short-duration,infrequentqueriesinanOLTPenvironmentwith limitedmemory❑B)accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory❑C)submittingbackupjobsatregular,24-hourIntervalsinanOLTPenvironment

6、withlimitedmemory❑D)performingbulk-loadoperationsinaDSSenvironmentwithlimitedmemory❑E)usingRecoveryManager(RMAN)torecoveradatabase •Answer:A5、Whichtwoaffectthetimetakenforinstancerecovery? ❑A)sizeofredologs❑B)sizeofUNDOtablespace ❑C)FAST_START_MTTR_TARGETvalue ❑D)sizeofarchivelogs❑E)sizeof

7、existingRMANbackupsets ❑F)UNDO_RETENTIONvalue •Answer:AC6、YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI).Youselectthe"InstallandConfigureGridInfrastructurefora StandaloneServer"option.WhichtaskisperformedbyOUIaspartofthisinstal