单项选择题

WhichofthefollowingOraclefeaturesisenabledbysettinganonzerovaluefortheMEMORY_TARGETinitializationparameter？（）

A.AutomaticPGAMemoryManagement
B.AutomaticSGAMemoryManagement
C.AutomaticSharedMemoryManagement
D.AutomaticMemoryManagement
E.ManualSGAMemoryManagement
F.Noneoftheabove
<上一题 目录 下一题>
热门 试题

单项选择题
Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE（PLAN=>’DSS_PLAN’，GROUP_OR_SUBPLAN=>’DSS_USERS’，NEW_CPU_P1=>80，NEW_SWITCH_GROUP=>’CANCEL_SQL’，NEW_SWITCH_ESTIMATE=>TRUE，NEW_SWITCH_TIME=>600）；Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds？（）
A.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：
B.UPDATE_PLAN_DIRECTIVE（PLAN=>’DSS_PLAN’，
单项选择题
WhichtypeofPL／SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspacerelatedproblem？（）
A.function
B.package
C.procedure
D.databasetrigger
E.anonymousPL/SQLblock
相关试题