SWITCH_TIME
SWITCH_GROUP
MAX_SESS_POOL
SWITCH_ESTIMATE
第1题:
Youexecutethefollowingblockofcode:SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(SIMPLE_PLAN=>’DEPARTMENTS’,CONSUMER_GROUP1=>’PAYROLLL’,GROUP1_CPU=>50,CONSUMER_GROUP2=>’SALES’,GROUP2_CPU=>25,CONSUMER_GROUP3=>’MARKETING’,GROUP3_CPU=>25);END;SQL>/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode?()
A.Youmustassignuserstoconsumergroups.
B.Youmustgranttheswitchprivilegetotheusers.
C.Youmustcreatearesourceplandirective.
D.Youmustspecifythecomplexresourceplan.
第2题:
You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives: Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario? ()
第3题:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention
第4题:
You issue the following code: EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP (’SCOTT’ ’GRP1’, TRUE); What will be the result of executing the above code?()
第5题:
Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()
第6题:
You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives: Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario?()
第7题:
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group?()
第8题:
A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.
第9题:
Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()
第10题:
create the Pending Area before creating the consumer group
activate the Pending Area before creating the consumer group
increase the size of the large pool to accommodate the Pending Area
increase the size of the shared pool to accommodate the Pending Area
increase the size of the database buffer cache to accommodate the Pending Area