You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）A. CREATE ROLE manager; GRANT create table

题目

You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）

A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

相似考题

1.Your little girl is becoming very rude. You ________ scold her.A.mayB.canC.ought toD.need

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.May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t

更多“You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. G ”相关问题

  • 第1题：

    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

  • 第2题：

    YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()

    A.RATIO

    B.EMPHASIS

    C.ACTIVE_SESS_POOL_MTH

    D.RESOURCE_DEGREE_LIMIT_ABSOLUTE


    参考答案：B

  • 第3题：

    Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：at"SYS.DBMS_RMIN"，line115ORA-06512：at"SYS.DBMS_RESOURCE_MANAGER"，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）

    A.activatethePendingAreabeforecreatingtheconsumergroup

    B.createthePendingAreabeforecreatingtheconsumergroup

    C.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea

    D.increasethesizeofthesharedpooltoaccommodatethePendingArea

    E.increasethesizeofthelargepooltoaccommodatethePendingArea


    参考答案：B

  • 第4题：

    Youarecreatingaresourceconsumergroupusingthe DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUPprocedure.Whichparameterwillyouusetodefinetheresourceschedulingmethodusedbetweensessionswithintheresourcegroup？（）

    A.CPU_MTH

    B.NEW_CPU_MTH

    C.CPU_P1

    D.CPU_P2


    参考答案：A

  • 第5题：

    Youissuedthefollowingblockofcode:SQL>BEGINDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’PROG_ROLE’,’DEVELOPERS’,FALSE);END;SQL>／WhichoptionisNOTaresultofexecutingtheabovecode?()

    A.TheswitchprivilegeisgrantedtothePROG_ROLErole.

    B.TheusersgrantedtherolePROG_ROLEwillbeabletoswitchtotheDEVELOPERSgroup.

    C.Theuserscannotgranttheswitchprivilegetootherusers.

    D.TheabovecodewillnotbeexecutedsuccessfullybecausetheGRANT_SWITCH_CONSUMER_GROUPprocedureisaninvalidprocedureinOracle10g.


    参考答案：D

  • 第6题：

    A goal of the()process is to determine the correctness of deliverables.

    A.Perform. Quality Assurance

    B.Plan Quality Management

    C.Control Quality

    D.Perform. Quality Improvement


    参考答案：C

相关内容