A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第1题
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第2题
A.AutomaticPGAMemoryManagement
B.AutomaticSGAMemoryManagement
C.AutomaticSharedMemoryManagement
D.AutomaticMemoryManagement
E.ManualSGAMemoryManagement
F.Noneoftheabove
第3题
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.
第4题
A.TheMTTRadvisorwillbedisabled.
B.Automaticcheckpointtuningwillbeenabled.
C.ThevaluefortheLOG_CHECKPOINT_INTERVALinitializationparameterwillbeoverridethevalueforFAST_START_MTTR_TARGET.
D.ThetimetakentorecovertheinstanceafterthecrashisalwaysexactlythesameasthevaluegivenfortheFAST_START_MTTR_TARGETinitializationparameter.
第5题
A.TheMTTRadvisorwillbedisabled.
B.Automaticcheckpointtuningwillbeenabled.
C.ThevaluefortheLOG_CHECKPOINT_INTERVALinitializationparameterwillbeoverridethevalueforFAST_START_MTTR_TARGET.
D.Thetimetakentorecovertheinstanceafterthecrashisalwaysexactlythesameasthevaluegivenfortheinitializationparameter.
第6题
A.RESUMABLE_SPACE_TIME
B.RESUMABLE_SPACE
C.RESUMABLE_TIME
D.RESUMABLE_TIMEOUT
E.TIME_RESUMABLE
第7题
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.
第8题
A.The authorities should not only be tolerant towards teenage misdeeds but also exert caution about the possible negative results the punishment brings.
B.The authorities should forgive the teenagers for their misbehaviors and show sympathy to them.
C.The authorities should show tolerance towards misbehaving teenagers and also study their misdeeds.
D.The authorities should punish the misbehaving teenagers in case they break rules again.
第9题
A.MEMORY_TARGETcanbeincreaseduptothevalueofMEMORY_MAX_TARGET,if MEMORY_MAX_TARGETissettoavaluegreaterthanzero
B.MEMORY_MAX_TARGETdefaultstoavalueofzeroifMEMORY_TARGETisnotset
C.MEMORY_TARGETrepresentsthetotalamountofmemorythatcanbeallocatedtoSGAandPGAmemorystructures.
D.MEMORY_TARGETisstaticandcannotbemodifiedwithoutshuttingdowntheinstance
第10题
A.TheMEMORY_MAX_TARGETparameterisautomaticallysetto500mb.
B.Thepga_AGGREGATE_TARGETandsga_TARGETparametersareautomaticallysettozero.
C.ThevalueoftheMEMORY_MAX_TARGETparameterremainszerountilitischangedmanually.
D.Thelowerboundsofpga_AGGREGATE_TARGETandsga_TARGETparametersaresetto90nband270mb,respectively
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!