Oracle
1Z0-034 · Question #78
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', COMM
The correct answer is B. create the Pending Area before creating the consumer group. See the full explanation below for the reasoning.
Question
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?
Options
- Aactivate the Pending Area before creating the consumer group
- Bcreate the Pending Area before creating the consumer group
- Cincrease the size of the database buffer cache to accommodate the Pending Area
- Dincrease the size of the shared pool to accommodate the Pending Area
- Eincrease the size of the large pool to accommodate the Pending Area
How the community answered
(51 responses)- A2% (1)
- B76% (39)
- C6% (3)
- D2% (1)
- E14% (7)
Community Discussion
No community discussion yet for this question.