(b) Explain the need for a first time group auditor to analyse the group structure. (5 marks)
Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1，foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’prod_plan’，CONSUMER_GROUP1=>’fin_group1’，GROUP1_CPU=>80，CONSUMER_GROUP2=>’pay_group1’，GROUP2_CPU=>20）ENDWhichthreestatementsaretrue？（）A.SYS_GROUPgets100%CPUresourcesatlevel1.B.FIN_GROUP1gets80%CPUresourcesatlevel1.C.FIN_GROUP1gets80%CPUresourcesatlevel2.D.PAY_GROUP1gets20%CPUresourcesatlevel1.E.PAY_GROUP1gets20%CPUresourcesatlevel2.F.OTHER_GROUPgets100%CPUresourcesatlevel1.G.OTHER_GROUPgets100%CPUresourcesatlevel2.
点击查看答案
Youexecutethefollowingblockofcode：SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’DEPARTMENTS’，CONSUMER_GROUP1=>’PAYROLLL’，GROUP1_CPU=>50，CONSUMER_GROUP2=>’SALES’，GROUP2_CPU=>25，CONSUMER_GROUP3=>’MARKETING’，GROUP3_CPU=>25）；END；SQL>/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode？（）A.Youmustassignuserstoconsumergroups.B.Youmustgranttheswitchprivilegetotheusers.C.Youmustcreatearesourceplandirective.D.Youmustspecifythecomplexresourceplan.
YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE（PLAN=>’SALES_PLAN’，GROUP_OR_SUBPLAN=>’MANAGERS’，CPU_P1=>100，CPU_P2=>0，SWITCH_GROUP=>’CLERKS’，SWITCH_TIME_IN_CALL=>600）；Auser，SCOTT，whoisassignedtotheMANAGERSgroup，startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete？（）
Youareusingthefollowingcommandtoclearthelogfilegroup:ALTERDATABASECLEARLOFFILEGROUP2;Inwhichcasewouldthecommandbesuccessful?()A.Group2istheactivegroup.B.Group2isthecurrentgroup.C.DatabaseisintheMOUNTstate.D.Group2hasbeenalreadyarchived.
Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’prod_plan’，CONSUMER_GROUP1=>’fin_group1’，GROUP1_CPU=>80，CONSUMER_GROUP2=>’pay_group1’，GROUP2_CPU=>20）；END；Whichthreestatementsaretrue？（）A.SYS_GROUPgets100%CPUresourcesatlevel1.B.FIN_GROUP1gets80%CPUresourcesatlevel1.C.FIN_GROUP1gets80%CPUresourcesatlevel2.D.PAY_GROUP1gets20%CPUresourcesatlevel1.E.PAY_GROUP1gets20%CPUresourcesatlevel2.F.OTHER_GROUPgets100%CPUresourcesatlevel1.G.OTHER_GROUPgets100%CPUresourcesatlevel2.
TherecordgroupintheEMPformispopulatedusingaSELECTstatementthatisconstructedprogrammaticallyatruntime.Fiveemployeerecordsaredisplayedatonetime,andauserchoosesitemtwofromtherecordgroup.Whichbuilt-inwouldyouusetodeterminewhichrowswereflaggedintherecordgroup?（）A.GET_GROUP_ROW_COUNTB.GET_GROUP_SELECTION_COUNTC.GET_GROUP_SELECTIOND.FIND_GROUPE.FIND_COLUMNF.ADD_GROUP_ROW
How are the slot groups arranged in the ERX 700 Series Edge Router?()A.Group1-Slots 0 & 1 Group 2 - Slot 2 Group 3- Slot 3 Group 4 - Slot 4B.Group1-Slots 2 & 3Group 2- Slot 4 Group 3-Slot 5 Group 4 - Slot 6C.Group1-Slot 2 Group 2- Slot 3 Group 3 - Slot 4 Group 4 - Slot 5 & 6D.Group1-Slot 3 Group 2 - Slot 4 Group 3 -Slot 5 Group 4 - Slots 6 & 7
