45.5
65
70
100
第1题:
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?()
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
第2题:
第3题:
You have recently created a serializable class named Vehicle.The class is shown below:[Serializable]public class Vehicle{public string VIN;public string Make;public string Model;public string Year;}You are planning to create a custom formatter class to control the formatting of Vehicle objects when they are serialized.You need to ensure that is achieved with as little development effort as possible.What should you do?()
A.
B.
C.
D.
第4题:
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()
第5题:
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement: SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’; What will be the outcome of this statement?()
第6题:
Youhavecreatedaresourceplan,DB_PLAN,usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan?()
A.assignuserstoconsumergroups
B.settheresourceplanfortheinstance
C.configureasimpleresourceplanandspecifyplandirectives
D.configureacomplexresourceplanandspecifyplandirectives
第7题:
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?()
第8题:
You would like to create a custom performance counter for an application that you created recently.To do this, you decide to create a custom category named ApplicationPerformance and a performance counter named HitNumber.You need to ensure that this counter is shared across numerous applications.What should you do?()
A.
B.
C.
D.
第9题:
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan?()
第10题:
You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users, SCOTT and BLAKE, belong to the DSS_USERS resource group. The user, SCOTT, initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive?()