单项选择题
A.The Resource Manager plan does not affect the user.
B.There must be a plan directive in any of the plans of the group to control the resources.
C.The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.
D.The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.
E.The members of this group can change their group without the database administrator’s intervention.
多项选择题 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?()
单项选择题 From the V$SESSION_LONGOPS view, you find that some of the database users have longrunning queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()