【OCP｜052】2018最新考试题库原题-4-cuug

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

1、052题库解析cuug-最新15道题www.cuug.com题库新特点：l更加灵活，题库的顺序与考试时的顺序每场都在变化l更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l不断有新的考题出现，目前最新已经更新到130道题www.cuug.com1、YourdatabaseIsconfiguredInarchivelogmode. TheUSERS01tablespaceIscurrentlyonline. Youarerequiredtotakethetablespaceoffline.Whichclauseorclausesensuretha

2、tnomediarecoveryisrequired whenthetablespaceIsbroughtbackonline?•❑A)eithertheNORMALortheTEMPORARYclause •❑B)onlytheNORMALclause•❑C)onlytheTEMPORARYclause •❑D)eithertheNORMALortheIMMEDIATEclause •❑E)onlytheIMMEDIATEclause •Answer:Bwww.cuug.com1offlinetemporary表空间时，如果表空间中没有offline的数据

3、文件，则online该表空间时不需要介质恢复。 2offlinetemporary表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执 行检查点操作3offlinetemporary表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数据文件需要介质恢复。www.cuug.com•2、Whichtwostatementsaretrueabouttablespaces? •❑A)Adatabasecancontainmultipleundotablespaces.•❑B)Ada

4、tabasecancontainonlyasingletemporarytablespace.•❑C)AdatabaseinstancestoresundodataIntheSYSTEMtablespaceIfnoundotablespaceexists.•❑D)AdatabaseinstancehangsIftheSYSAUXtablespacebecomesunavailable.•❑E)AdatabasewithalocallymanagedSYSTEMtablespacecanhavedictionary-managedusertablepaces.

5、•Answer:AEwww.cuug.com•3、YouwanttoInstallOracle11gdatabasesoftwareandcreateadatabaseonASMImmediatelyaftertheInstall.YourplanistoinstallbothOracledatabaseandGridInfrastructure. Whichtwoaretrueinthisscenario?•❑A)GridInfrastructuremustbeinstalledfirst.•❑B)BothproductsmustbeInstalledby

6、thesameOSuser.•❑C)EachproductmustbeInstalledInadifferentORACLE_HOME.•❑D)BothproductscansharetheOSgroupassignedtotheirOSDBAandOSOPERprivilegedgroups•❑E)BothproductsmustbeinstalledbyusingthesameORACLE_BASE.www.cuug.com•❑F)Bothproductsmustbeofthesameversion. •Answer:ACwww.cuug.com4、Wh

7、ichistrueaboutinvalidPL/SQLobjects?•❑A)Theyareautomaticallyrecompiledagainstthenew definitionofareferencedobjectatthesametimeasthe referencedobjectismodified.•❑B)TheycanbemanuallyrecompiledonlybyusingSQLcommands.•❑C)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferenced

8、objectwhentheyarecalled.•❑