Oracle Exam 1Z0-034 Topic 11 Question 4 Discussion

Actual exam question for Oracle's 1Z0-034 exam

Question #: 4
Topic #: 11

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?

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

Show Suggested Answer

Suggested Answer: B

by Tracey at Dec 24, 2022, 09:42 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!