YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement:SQL>SELECTname,value,isdefault2FROMv$parameter3WHEREnameLIKE’%size

题目

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.


相似考题
参考答案和解析
参考答案:C, E