网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)
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
参考答案
更多 “ For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.) 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 timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources ” 相关考题
考题
"You _________ finish your homework before the dinner." said mother.
A.shouldB.have toC.mustD.would
考题
以下程序段的输出结果为 ( )int j=2;switch(j){case 2:System.out.print("two.");case 2+1:System.out.println("three.");breakdefault:System.out.println("value is"+j);break;}A.two.three.B.two.C.three.D.value is 2
考题
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?()
考题
YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()
A.RATIOB.EMPHASISC.ACTIVE_SESS_POOL_MTHD.RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
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.
考题
YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis?()
A.DBMS_REPAIRB.DBMS_SCHDULERC.DBMS_STATSD.DBMS_RESOURCE_MANAGER
考题
WhichofthefollowingareassociatedwiththeapplicationlayeroftheOSImodel?(two.)()
A.pingB.TelnetC.FTPD.TCPE.IP
热门标签
最新试卷