OCP考试052必威体育精装版考试题库原题-11-20180817.pdf

052 题库解析 OCP 考试 052 必威体育精装版考试题库原题 -11 ? 十 .Initializationparameter 70.whichis true aboutinitializationparameteradministration? A)Some Dynamicparametervaluescanbe modi?ed to affectonlyone session B)Dynamicparameters,when modi?ed, alwaysrevertto their original valuesafter thedatabaseinstanceisrestarted C)Staticparametervaluescanbechangedinthe sp?le only byusing thealtersystemcommandwithscope= sp?le whenthedatabaseis closed D)Staticparametervaluescanbechangedforthecurrentinstanceby usingaltersystemcommandwithscope=memory Answer ：A （验证过） 71.Youwantto usetheALTERSYSTEMstatement withSCOPE=MEMORY tochangeaninitializationparametervalue. Whichis true? A) It canbeusedonlyifa p?leis used. B)Thechangeoccursimmediatelyinmemoryfor staticparametersbutit is notpersistentafter instancerestart. C)Thechangeoccurs immediateinmemoryfor dynamicparametersbutitis notpersistentafter instancerestart. D) In canbeusedonlyifan sp?le is used. Answer ：C 72.whichthreestatementsaretrueaboutinitializationparametersand ?les? A)An idleinstancemuststart witha PFILE. B) Session modi?able initializationparameterscanonly bechangedbya userwiththeDBArole. C)TheALTERSYSTEMcommandcanbeusedtochangeparameter valuesfor aninstancestarted usinga PFILE. D)AnSPFILEcanbecreatedfrom anidleinstance. E) Session modi?able initializationparameterscanonly bechangedonce persession. F)TheALTERSYSTEMcommandcanbeusedto changeparameter valuesfor aninstancestarted usinganSPFILE G) System modi?able initializationparameterscanonlybechangedbythe SYSuser. Answer ：DFG ? 十? 一.Backup 73.TableEMPresidesinthe USERStablespace.Examinethis command: SQLDROPTABLEemp PURGE; Whichtwomethodswouldyouuseto recoverEMP? A) FlashbackTable. B) re-creatingthetableandreinsertingtherows. C) performingatablespace