OCP考试052最新考试题库原题-11-20180817

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

1、052题库解析最新题库052-题库解析-11-20180817052题库解析CUUG真诚奉献题库新特点：l最新052题库，按知识点分门别类，方便大家学习每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：www.cuug.com⼆十.Initializationparameter70.whichistrueaboutinitializationparameteradministration?A)SomeDynamicparame

2、tervaluescanbemodifiedtoaffectonlyonesessionB)Dynamicparameters,whenmodified,alwaysreverttotheiroriginalvaluesafterthedatabaseinstanceisrestartedC)Staticparametervaluescanbechangedinthespfileonlybyusing thealtersystemcommandwithscope=spfilewhenthedatabaseis close

3、dD)Staticparametervaluescanbechangedforthecurrentinstanceby usingaltersystemcommandwithscope=memoryAnswer：A（验证过）71.YouwanttousetheALTERSYSTEMstatementwithSCOPE=MEMORY tochangeaninitializationparametervalue. Whichistrue?A)Itcanbeusedonlyifapfileisused.B)Thechan

4、geoccursimmediatelyinmemoryforstaticparametersbutitis notpersistentafterinstancerestart.C)Thechangeoccursimmediateinmemoryfordynamicparametersbutitis notpersistentafterinstancerestart.D)Incanbeusedonlyifanspfileisused.Answer：C72.whichthreestatementsaretrueabou

5、tinitializationparametersandfiles?A)AnidleinstancemuststartwithaPFILE.B)SessionmodifiableinitializationparameterscanonlybechangedbyauserwiththeDBArole.C)TheALTERSYSTEMcommandcanbeusedtochangeparameter valuesforaninstancestartedusingaPFILE.D)AnSPFILEcanbecreated

6、fromanidleinstance. E)Sessionmodifiableinitializationparameterscanonlybechangedonce persession.F)TheALTERSYSTEMcommandcanbeusedtochangeparameter valuesforaninstancestartedusinganSPFILEG)SystemmodifiableinitializationparameterscanonlybechangedbytheSYSuser.Answer

7、：DFG⼆十⼀一.Backup73.TableEMPresidesintheUSERStablespace.Examinethiscommand:SQL>DROPTABLEempPURGE;WhichtwomethodswouldyouusetorecoverEMP? A)FlashbackTable.B)re-creatingthetableandreinsertingtherows. C)performingatablespacepointintimerecoveryofUSERS. D)FlashbackT

8、ransactionBackout.E)FlashbackDrop.Answer：BC74.Whichtwoaretrueaboutconsistentdatabasebackups? A)TheycanonlybetakenbyusingRMANcommands. B)TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOU