OCP考试052最新考试题库原题-4-20180601

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

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

2、requiredtotakethetablespaceoffline.Whichclauseorclausesensurethatnomediarecoveryisrequired whenthetablespaceIsbroughtbackonline?•❑A)eithertheNORMALortheTEMPORARYclause •❑B)onlytheNORMALclause•❑C)onlytheTEMPORARYclause •❑D)eithertheNORMALortheIMMEDIATEclause •❑E)onlytheIMMEDIATEclause •Ans

3、wer:B1offlinetemporary表空间时，如果表空间中没有offline的数据文件，则online该表空间时不需要介质恢复。 2offlinetemporary表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执 行检查点操作3offlinetemporary表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数据文件需要介质恢复。•2、Whichtwostatementsaretrueabouttablespaces? •❑A)Adatabasecancontainmulti

4、pleundotablespaces.•❑B)Adatabasecancontainonlyasingletemporarytablespace.•❑C)AdatabaseinstancestoresundodataIntheSYSTEMtablespaceIfnoundotablespaceexists.•❑D)AdatabaseinstancehangsIftheSYSAUXtablespacebecomesunavailable.•❑E)AdatabasewithalocallymanagedSYSTEMtablespacecanhavedictionary-man

5、agedusertablepaces.•Answer:AE•3、YouwanttoInstallOracle11gdatabasesoftwareandcreateadatabaseonASMImmediatelyaftertheInstall.YourplanistoinstallbothOracledatabaseandGridInfrastructure. Whichtwoaretrueinthisscenario?•❑A)GridInfrastructuremustbeinstalledfirst.•❑B)BothproductsmustbeInstalledby

6、thesameOSuser.•❑C)EachproductmustbeInstalledInadifferentORACLE_HOME.•❑D)BothproductscansharetheOSgroupassignedtotheirOSDBAandOSOPERprivilegedgroups•❑E)BothproductsmustbeinstalledbyusingthesameORACLE_BASE.•❑F)Bothproductsmustbeofthesameversion. •Answer:AC4、WhichistrueaboutinvalidPL/SQLobje

7、cts?•❑A)Theyareautomaticallyrecompiledagainstthenew definitionofareferencedobjectatthesametimeasthe referencedobjectismodified.•❑B)TheycanbemanuallyrecompiledonlybyusingSQLcommands.•❑C)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectwhentheya