(b) Explain the need for a first time group auditor to analyse the group structure. (5 marks)
第1题:
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.
第2题:
A.Group1-Slots 0 & 1 Group 2 - Slot 2 Group 3- Slot 3 Group 4 - Slot 4
B.Group1-Slots 2 & 3Group 2- Slot 4 Group 3-Slot 5 Group 4 - Slot 6
C.Group1-Slot 2 Group 2- Slot 3 Group 3 - Slot 4 Group 4 - Slot 5 & 6
D.Group1-Slot 3 Group 2 - Slot 4 Group 3 -Slot 5 Group 4 - Slots 6 & 7
第3题:
7、使用下面哪个命令可以将用户user1加入到用户组group1中
A.useradd -a user1 group1
B.groupadd -a user1 group1
C.gpasswd -a user1 group1
D.gshadow -a user1 group1
第4题:
TherecordgroupintheEMPformispopulatedusingaSELECTstatementthatisconstructedprogrammaticallyatruntime.Fiveemployeerecordsaredisplayedatonetime,andauserchoosesitemtwofromtherecordgroup.Whichbuilt-inwouldyouusetodeterminewhichrowswereflaggedintherecordgroup?()
A.GET_GROUP_ROW_COUNT
B.GET_GROUP_SELECTION_COUNT
C.GET_GROUP_SELECTION
D.FIND_GROUP
E.FIND_COLUMN
F.ADD_GROUP_ROW
第5题:
A.group3
B.group1
C.group5
D.group7
第6题:
70、使用下面哪个命令可以将用户user1加入到用户组group1中
A.useradd -a user1 group1
B.groupadd -a user1 group1
C.gpasswd -a user1 group1
D.group -a user1 group1