网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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***
参考答案
更多 “ 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*** ” 相关考题
考题
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
考题
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：atSYS.DBMS_RMIN，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage
考题
Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives
考题
Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEPARTMENTS’，CPU_P1=0）；END；Then，youissuethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEVELOPERS’，CPU_P2=100）；END；Whatwillbetheimpactofexecutingtheabovecode？（）
考题
Youarecreatingaresourceconsumergroupusingthe DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUPprocedure.Whichparameterwillyouusetodefinetheresourceschedulingmethodusedbetweensessionswithintheresourcegroup？（）A.CPU_MTHB.NEW_CPU_MTHC.CPU_P1D.CPU_P2
考题
YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()
A.RATIOB.EMPHASISC.ACTIVE_SESS_POOL_MTHD.RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
Youissuedthefollowingblockofcode:SQLBEGINDBMS_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.
考题
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：atSYS.DBMS_RMIN，line115ORA-06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.activatethePendingAreabeforecreatingtheconsumergroupB.createthePendingAreabeforecreatingtheconsumergroupC.increasethesizeofthedatabasebuffercachetoaccommodatethePendingAreaD.increasethesizeofthesharedpooltoaccommodatethePendingAreaE.increasethesizeofthelargepooltoaccommodatethePendingArea
考题
A goal of the()process is to determine the correctness of deliverables.
A.Perform. Quality AssuranceB.Plan Quality ManagementC.Control QualityD.Perform. Quality Improvement
热门标签
最新试卷
