欢迎来到天天文库
浏览记录
ID:21430453
大小:114.36 KB
页数:20页
时间:2018-10-22
《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
此文档下载收益归作者所有