Oracle
1Z0-043 · Question #197
1Z0-043 Question #197: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #197. The question stem and answer options stay visible for context.
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
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.