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.

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.


相关考题:

《物业管理条例》规定,业主在物业管理活动中享有的权利包括()。 A.提议召开业主大会会议,并就物业管理的有关事项提出建议B.提出制定和删除业主条约、业主大会议事规则的建议C.参加业主大会会议,行使投票权D.选举业主委员会委员,并享有被选举权E.监督业主委员会的工作

《京都议定书》首次确定了发展中国家减少温室气体排放量的具体指标,区分了发达国家和发展中国家的不同义务。() 此题为判断题(对,错)。

DuringtheIPv6addressresolution,anodesendsaneighborsolicitationmessageinordertodiscoverwhichofthese?() A.TheLayer2multicastaddressofthedestinationnodeB.ThesolicitednodemulticastaddressofthedestinationnodeC.TheLayer2addressofthedestinationnodebasedonthedestinationIPv6addressD.TheIPv6addressofthedestinationnodebasedonthedestinationLayer2address

虽然能提供Internet服务的机构日益增多,但就其对教育领域的影响来看,仍然以中国教育科研信息网(CERNET)为大,那么,CERNET建设的第一阶段是到()底。 A.1992年B.1993年C.1994年D.1995年

一般卫星系统由控制段,地面段和(). A.空间段B.传播段C.传输段D.大气层段