网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
TheSPFILEforyourdatabasecontainsthefollowingparametersettings：SGA_TARGET=1000MDB_CACHE_SIZE=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents？（）
A.940M
B.990M
C.690M
D.1000M
参考答案
更多 “ TheSPFILEforyourdatabasecontainsthefollowingparametersettings：SGA_TARGET=1000MDB_CACHE_SIZE=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents？（）A.940MB.990MC.690MD.1000M ” 相关考题
考题
TheSPFILEforthePRODdatabasespecifiesthefollowinginitializationparametervalues：SGA_TARGET=2GDB_8K_CACHE_SIZE=128MYoucreateatablespacenamedHRwiththenon-standardblocksizeof8K.FourdatabaseusersarerunningqueriesonatableintheHRtablespace.Theseuserscomplainthatthequeriesaretakinglongerthanusualtocomplete.Whileinvestigatingthereasonsforthisdelay，youdiscoverthatthedatabaseencountersextensivecachemissesonthedatabasebuffercachewiththeblocksizeof8K.YouissuethefollowingstatementtoincreasethevalueoftheDB_8K_CACHE_SIZEinitializationparameterto256M：SQLALTERSYSTEMSETDB_8K_CACHE_SIZE=256MSCOPE=BOTH；Whatistheresultofthisstatement？（）
考题
YouareconfiguringthePRODdatabasetouseaninternaltuningalgorithmtomonitortheperformanceoftheworkload.Toachievethisconfiguration，youspecifythefollowingparametersettingsintheSPFILE：SGA_TARGET=512MSHARED_POOL_SIZE=256MWhichtwostatementsaretruewhenmodifyingtheSHARED_POOL_SIZEinitializationparameterintheSPFILE？（）A.ModifyingtheSHARED_POOL_SIZEinitializationparametercannotbeaccomplishediftheSGA_TARGETinitializationparameterissettoanon-zerovalue.B.ModifyingthevalueoftheSHARED_POOL_SIZEinitializationparametertozeroisnotallowediftheSGA_TARGETinitializationparameterissettoanonzerovalue.C.IncreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterdoesnotincreasethesharedpoolcomponentsize.Itsetsthelowerlimitforthesizeofthiscomponent.D.DecreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterdoesnotreducethesizeofthesharedpoolcomponentimmediately.Itsetsthelowerlimitforthesizeofthiscomponent.E.IncreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterimmediatelyincreasesthesharedpoolcomponenttothedesiredsizebyreallocatingtheadditionalmemoryfromtheauto-tunedmemorycomponents.F.DecreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterimmediatelyshrinksthesharedpoolcomponenttothedesiredsizewhilereallocatingthereleasedmemorytothememorycomponentsthatarenotauto-tuned.
考题
YourSPFILEcontainsthefollowingparametersettings：SGA_TARGET=8GDB_CACHE_SIZE=4GSHARED_POOL_SIZE=2GLARGE_POOL_SIZE=512MJAVA_POOL_SIZE=512MLOG_BUFFER=100MSGA_MAX_SIZE=10GYouquerytheV$SGA_DYNAMIC_COMPONENTSdynamicperformanceviewanddiscoverthatthelargepoolcomponentiscurrentlysizedat1G.YouwantthevalueoftheSGA_TARGETinitializationparameterto10G，butinsteadofspecifyingavalueof10GfortheSGA_TARGETinitializationparameter，youerroneouslyexecutethefollowingstatement：SQLALTERSYSTEMSETSGA_TARGET=0SCOPE=BOTH；Whatistheresultofthisstatement？（）
考题
YoucreateanOracle10gdatabaseandconfiguretheSPFILEasfollows：SGA_TARGET=2GDB_CACHE_SIZE=512MLOG_BUFFER=50MDB_KEEP_CACHE_SIZE=128MYoumodifytheSGA_TARGETinitializationparameterusingthefollowingstatement：SQLALTERSYSTEMSETSGA_TARGET=1GSCOPE=BOTH；Whichentitydoesthisstatementaffect？（）A.onlytheauto-tunedmemorycomponentsB.onlythememorycomponentsthatarenotauto-tunedC.boththeauto-tunedmemorycomponentsandthenon-auto-tunedmemorycomponentsD.neithertheauto-tunedmemorycomponentsnorthenon-auto-tunedmemorycomponents
考题
YouenabledAutomaticSharedMemoryManagement.Theinitializationparametersaresetasshownbelow：SGA_TARGET=10GBSGA_MAX_SIZE=14GBSTREAMS_POOL_SIZE=1GBSHARED_POOL_SIZE=3GBWhichtwostatementsarecorrectinthisscenario？（）A.Atotalof14GBmemorywillbeallocatedtotheautomaticallytunedmemorycomponentsB.ReducingthevalueforSGA_TARGETto9GBwillautomaticallydecreasethememoryallocatedtosharedpoolfrom3GBto2GBC.ThevalueforSGA_TARGETcanbeincreaseduptoamaximumof14GBD.Amaximumof3GBcanbeallocatedtosharedpoolE.IncreasingthevalueforSGA_TARGETto12GBwillautomaticallyincreasethememoryallocatedtoautotunedparametersF.IncreasingthevalueforSGA_TARGETwillautomaticallyincreasethememoryallocatedforSTREAMS_POOL_SIZE
热门标签
最新试卷