网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
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 ” 相关考题
考题 Ifyoudon’tliketoswim,you_____aswellstayathome.A)shouldB)mayC)canD)would

考题 "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