单项选择题

Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）
A.byusingtheDBMS_SESSIONpackage
B.bygrantingtheDBArole
C.byusingtheDBMS_RESOURCE_MANAGERpackage
D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage

A.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）
A.byusingtheDBMS_SESSIONpackage
B.bygrantingtheDBArole
C.byusingtheDBMS_RESOURCE_MANAGERpackage
D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage

你可能感兴趣的试题

单项选择题

TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）
A.ThestatementwilldeactivateDAY_PLAN.
B.ThestatementwillactivateDAY_PLANasthetopplan.
C.ThestatementwillactivateMANAGERS_PLANasthetopplan.
D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.

A.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）
A.ThestatementwilldeactivateDAY_PLAN.
B.ThestatementwillactivateDAY_PLANasthetopplan.
C.ThestatementwillactivateMANAGERS_PLANasthetopplan.
D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.

单项选择题

Whichstatementistrueregardingsynonyms?（）

A.Synonymscanbecreatedonlyforatable
B.Synonymsareusedtoreferenceonlythosetablesthatareownedbyanotheruser
C.Apublicsynonymandaprivatesynonymcanexistwiththesamenameforthesametable
D.TheDROPSYNONYMstatementremovesthesynonym,andthetableonwhichthesynonymhasbeencreatedbecomesinvalid