第1题:
TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently,alotofinsertactivityistakingplaceinthedatabase,andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces,youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged?()
A.LOG_BUFFER
B.DB_CACHE_SIZE
C.JAVA_POOL_SIZE
D.LARGE_POOL_SIZE
E.SHARED_POOL_SIZE
F.STREAMS_POOL_SIZE
第2题:
第3题:
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.
第4题:
何谓断裂基因(split gene)?何谓重叠基因(overlapping gene)?它们在生物进化与适应上有何意义?
第5题:
gene pool
第6题:
A.DB_CACHE_SIZE
B.SHARED_POOL_SIZE
C.LARGE_POOL_SIZE
D.JAVA_POOL_SIZE
E.SGA_MAX_SIZE
F.SORT_AREA_SIZE
第7题:
育种原始材料根据亲缘关系划分,包括()、次级基因库、和三级基因库。
第8题:
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.
第9题:
次级基因库(gene pool2)
第10题:
下列关于种群基因库的叙述中,错误的是()