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

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

1、cuug-052题库解析最新题库www.cuug.com052题库解析CUUG真诚奉献www.cuug.com题库新特点：l最新052题库，按知识点分门别类，方便大家学习www.cuug.com⼆十.Initializationparameter70.whichistrueaboutinitializationparameteradministration?A)SomeDynamicparametervaluescanbemodifiedtoaffectonlyonesessionB)Dynamicparam

2、eters,whenmodified,alwaysreverttotheiroriginalvaluesafterthedatabaseinstanceisrestartedC)Staticparametervaluescanbechangedinthespfileonlybyusing thealtersystemcommandwithscope=spfilewhenthedatabaseis closedD)Staticparametervaluescanbechangedforthecurrentinsta

3、nceby usingaltersystemcommandwithscope=memoryAnswer：A（验证过）www.cuug.com71.YouwanttousetheALTERSYSTEMstatementwithSCOPE=MEMORY tochangeaninitializationparametervalue. Whichistrue?A)Itcanbeusedonlyifapfileisused.B)Thechangeoccursimmediatelyinmemoryforstaticpar

4、ametersbutitis notpersistentafterinstancerestart.C)Thechangeoccursimmediateinmemoryfordynamicparametersbutitis notpersistentafterinstancerestart.D)Incanbeusedonlyifanspfileisused.Answer：Cwww.cuug.com72.whichthreestatementsaretrueaboutinitializationparameter

5、sandfiles?A)AnidleinstancemuststartwithaPFILE.B)SessionmodifiableinitializationparameterscanonlybechangedbyauserwiththeDBArole.C)TheALTERSYSTEMcommandcanbeusedtochangeparameter valuesforaninstancestartedusingaPFILE.D)AnSPFILEcanbecreatedfromanidleinstance. E

6、)Sessionmodifiableinitializationparameterscanonlybechangedonce persession.F)TheALTERSYSTEMcommandcanbeusedtochangeparameter valuesforaninstancestartedusinganSPFILEG)SystemmodifiableinitializationparameterscanonlybechangedbytheSYSuser.Answer：DFGwww.cuug.com⼆十

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

8、sactionBackout.E)FlashbackDrop.Answer：BCwww.cuug.com74.Whichtwoaretrueaboutconsistentdatabasebackups? A)TheycanonlybetakenbyusingRMANcommands. B)TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOUNT state.C)T