Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

A、 The user must have been granted the DBA role.

B、 The user must have been granted the switch privilege as a part of a role.

C、 The user must have been granted the Resource Manager administrator privilege.

D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

相关问题推荐

• 下列程序的运行结果为 #include＜iostream.h＞ template＜class TT＞ class FF {TT a1，a2，a3； public： FF(TT b1，TT b2，TT b3){a1＝b1；a2=b2；a3＝b3；} TT Sum(){return a1+a2+a3；}}； void main() { FF＜int＞x(int(1.1)，2，3)，y(int(4.2)，5，6)； cout＜＜x.Sum()＜＜‘‘＜

  A．6.1 15.2

  B．6 15

  C．6 15.2

  D．6.1 15

  查看答案

• You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

  A、 Memory Advisor

  B、 Segment Advisor

  C、 SQL Access Advisor

  D、 Automatic Workload Repository （AWR）

  E、 Automatic Database Diagnostic Monitor （ADDM）

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

  A、 Disable SQL tracing for the APPS tablespace.

  B、 Disable logging attributes for the APPS tablespace.

  C、 Modify the tablespace to be a dictionary-managed tablespace.

  D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.

  E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

  查看答案

• The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

  A

   LOG_BUFFER

  B

   DB_CACHE_SIZE

  C

   JAVA_POOL_SIZE

  D

   LARGE_POOL_SIZE

  E

   SHARED_POOL_SIZE

  F

   STREAMS_POOL_SIZE

  查看答案

• 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.

  查看答案