black

1z0-043

多项选择题

You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1， for a plan，PROD_PLAN： 
BEGIN 
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN => ’prod_plan’， 
CONSUMER_GROUP1 => ’fin_group1’， 
GROUP1_CPU => 80， 
CONSUMER_GROUP2 => ’pay_group1’， 
GROUP2_CPU => 20）; 
END; 
Which three statements are true？（）

A.SYS_GROUP gets 100% CPU resources at level 1.
B.FIN_GROUP1 gets 80% CPU resources at level 1.
C.FIN_GROUP1 gets 80% CPU resources at level 2.
D.PAY_GROUP1 gets 20% CPU resources at level 1.
E.PAY_GROUP1 gets 20% CPU resources at level 2.
F.OTHER_GROUP gets 100% CPU resources at level 1.
G.OTHER_GROUP gets 100% CPU resources at level 2.

相关考题

单项选择题 YouareusingResourceManagertomanagesystemresources.Whilecreatinganewdatabaseuser，youobservethattheuserisamemberofDEFAULT_CONSUMER_GROUPbydefault.Whatwouldbetheimplicationsofthis？（）

多项选择题 View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）

多项选择题 Inyourproductiondatabase，youobservethatusers’transactionsareconsumingalotofresourcesandyouplantoimposeresourcerestrictionsbyusingResourceManager.ForwhichthreeresourcescanyouenableusagerestrictionsbyusingResourceManager？（）

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号：湘ICP备2020024380号-3