试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Given: Whatistheres
- Examine the structu
- ote the f
- Which SELECT stateme
- Given： What is
- Evaluate the SQL sta
- Which statemen
- Which two are true a
- User SCOTT wants to
- Which three statemen
- Which two statements
- ClicktheExhibitbutto
- Which two̳
- 在SQL*PLUS中执行刚输入的一条命令
- When tuning
- A developer
- 在命令行中启动SQL*Plus，使用如下
- For which two action
- What is t
- The warning