单项选择题

ourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）

A.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）

你可能感兴趣的试题

单项选择题

Youareworkingonaninstancestartedusing&81

A.YouwanttomovetheFlashRecoveryAreaofyourdatabasetoanewlocation.YouwanttheFlashbacklogfilestobestoredinthenewlocation.Givenbeloware
B.Shutdowntheinstance.
C.ChangethevalueoftheDB_RECOVERY_FILE_DESTinitializationparametertoanewvalue.
D.ExecutetheALTERDATABASEFLASHBACKOFFcommand.
E.Startuptheinstanceandmountthedatabase.
F.ExecutetheALTERDATABASEFLASHBACKONcommand.
G.Openthedatabase.

单项选择题

Thewarninglevelthresholdvalueforatablespace，&ens

A.Thetablespace，DATA1，isinfrequentlyusedandisnotapartoftheproductionenvironment.Youissuedthefollowingcommand：
B.SET_THRESHOLD
C.tablespace_pct_full，
D.operator_ge，80，
E.operator_ge，90，
F.object_type_tablespace，’DATA’）；