单项选择题
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
相关考题
-
单项选择题
YouneedtocreateaschedulethatwillrunajobonthesecondFridayofeachmonth.Whatshouldtherepeatintervaloftheschedulebesetto?()
A. FREQ = MONTHLY; BYDAY = 2FRI;
B. FREQ = MONTHLY; BYDAY = FRI(2);
C. FREQ = MONTHLY; BYDAY = FRI2;
D. FREQ = MONTHLY; BYDAY = -2FRI; -
多项选择题
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? ()
A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE -
单项选择题
Verysoonyouwillbeperformingmaintenanceoperations.Youwouldhaveseveraljobstorunassoonasthemaintenanceperiodstarts.Whichmethodwouldyouusetocreatejobswithoutspecifyingthetimeperiodwhenthejobshouldberun?()
A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import
