YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement:SQLSELECTname,value,isdefault2FROMv$parameter3WHEREnameLIKE’%size%’;TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply?()A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement:SQL>SELECTname,value,isdefault2FROMv$parameter3WHEREnameLIKE’%size%’;TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply?()

A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1G

B.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1G

C.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGA

D.ThevaluesoftheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.

E.NominimumlimitsareimposedontheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameters.

F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.


相关考题:

在制作过程中,如果对页面版式不满意,可通过()菜单中的"幻灯片版式"来调整。 A.格式B.工具C.文件D.视图

“中国冰雪”标识是国家体育总局冬运中心的官方标识。() 此题为判断题(对,错)。

反铲挖掘机主要用于小型基坑、基槽和管沟开挖。( ) 此题为判断题(对,错)。

镇海海防遗址不仅是全国重点文物保护单位,更是一个活生生的爱国主义教育基地。() 此题为判断题(对,错)。

YouarecreatingaWindowsFormsapplicationbyusingthe.NETFramework3.5.Theapplicationisconfiguredtouserolebasedsecurity.Youneedtoensurethatuserscanprintreportsonlybyselectingaprinterfromtheprinterdialogbox.Youwanttoachievethisgoalbyusingtheminimumlevelofpermission.Whichcodesegmentshouldyouuse?()A.AB.BC.CD.D

你有一个Vista和Windows 7双启动的计算机,以下哪个命令可以编辑来强制PC启动时默认从Vista启动?() A.boot.iniB.ntfsboot.cfgC.bcdedit.exeD.system.cfg

专利申请号为98328199的发明项目名称是()。 A.基于单片机的网络电视机顶盒B.互联网共享器C.立式组合互联网共享器D.卧式组合互联网共享器

著名的ABCD中A代表()。 A.对象B.行为C.条件D.标准