For which two situations would you use functionality provided by the Resource Manager?()A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled time

题目
For which two situations would you use functionality provided by the Resource Manager?()

A. setting idle timeout limits on resource plans

B. saving storage space by using compressed backup sets

C. creating jobs that will run automatically at a scheduled time

D. assigning priorities to jobs to manage access to system resources

E. creating alerts to perform notification when tablespaces are low on available space resources

相似考题

1.If you don’t like to swim, you _____as well stay at home.A)should B)may C)can D)would

2.Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：at"SYS.DBMS_RMIN"，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER"，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage

3.Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives

4."You _________ finish your homework before the dinner." said mother.A.shouldB.have toC.mustD.would

参考答案和解析
参考答案：A, D
更多“For which two situations would you use functionality provided by the Resource Manager?() ”相关问题

  • 第1题：

    Manually，yousettheconsumergroupofallofthenewlycreateduserstoMYDB_GRP.Youwanttheuserstobeabletochangetheirconsumergroupsaspertheapplicationrequirement.Whatwasthefirststepthatwasneededintheprocesstoachievethisobjective？（）

    A.TheusermusthavebeengrantedtheDBArole.

    B.Theusermusthavebeengrantedtheswitchprivilegeasapartofarole.

    C.TheusermusthavebeengrantedtheResourceManageradministratorprivilege.

    D.TheusermusthavebeengrantedtheswitchprivilegebyusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage.


    参考答案：D

  • 第2题：

    YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()

    A.RATIO

    B.EMPHASIS

    C.ACTIVE_SESS_POOL_MTH

    D.RESOURCE_DEGREE_LIMIT_ABSOLUTE


    参考答案：B

  • 第3题：

    Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?()

    A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.

    B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.

    C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.

    D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.


    参考答案：A

  • 第4题：

    Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEPARTMENTS’，

    CPU_P1=0）；

    END；

    Then，youissuethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEVELOPERS’，

    CPU_P2=100）；

    END；

    Whatwillbetheimpactofexecutingtheabovecode？（）


    参考答案：B

  • 第5题：

    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


    参考答案：D

  • 第6题：

    YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis?()

    A.DBMS_REPAIR

    B.DBMS_SCHDULER

    C.DBMS_STATS

    D.DBMS_RESOURCE_MANAGER


    参考答案：A

相关内容