多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’,  COMMENT => ’New Group’);  This command errors out displaying the following message:  ERROR at line 1:  ORA-29371: pending area is not active  ORA-06512: at "SYS.DBMS_RMIN", line 115  ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108  ORA-06512: at line 1  What action would you take to overcome this error?()

  • A、 activate the Pending Area before creating the consumer group
  • B、 create the Pending Area before creating the consumer group
  • C、 increase the size of the database buffer cache to accommodate the Pending Area
  • D、 increase the size of the shared pool to accommodate the Pending Area
  • E、 increase the size of the large pool to accommodate the Pending Area
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题