单选题You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）AThe job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.BThe job aff

第1题：

第2题：

You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10.  Consumer group MEDIUM_CG with CPU_P1 as 5.  Consumer group LOW_CG with CPU_P1 as 2.  Consumer group OTHER_GROUPS with CPU_P1 as 1.  Which statement is correct in this scenario？（）

• A、 The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
• B、 The members of the HIGH_CG consumer group would get 10% of the CPU.
• C、 The plan PROD_DB_PLAN can have subplans.
• D、 The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.

第3题：

Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）  

• A、 Window
• B、 Program
• C、 Job_Class
• D、 Window group

第4题：

Which three statements are true about windows? （）(Choose three.)

• A、Only one window can be open at any given time
• B、Consumer groups are associated with windows
• C、Windows work with job classes to control resource allocation
• D、The database service name must be provided during windows creation
• E、Windows can automatically start job or change resource allocation among jobs for various time periods.

第5题：

Which three statements are true about windows？（） 

• A、 Only one window can be open at any given time
• B、 Consumer groups are associated with windows
• C、 Windows work with job classes to control resource allocation
• D、 The database service name must be provided during windows creation
• E、 Windows can automatically start job or change resource allocation among jobs for various time periods.

第6题：

Which two statements are true about a job chain？（）

• A、 A job chain can contain a nested chain of jobs
• B、 The jobs in a job chain cannot have more than one dependency
• C、 A job of the CHAIN type can be run using event-based or time-based schedules
• D、 The jobs in a job chain can be executed only by using the events generated by the Scheduler

第7题：

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）

• A、Increasing the priority of the job class to which the job belongs
• B、Increasing the job's relative priority within the Job class to which it belongs
• C、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D、Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E、Increasing the value of the JOB_QUEUE_PROCESSES parameter
• F、Increasing the priority of the scheduler window to which the job belongs

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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？（） 

• A、 CPU_MTH
• B、 NEW_CPU_MTH
• C、 CPU_P1
• D、 CPU_P2

第14题：

Consider the following code snippet：   BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE （ name => ，，lne_job1， attribute => ，，job_priority， value => 1）；  END；  /   If this code were executed， which of the following statements would be true？（）

• A、 The priority of the lne_job1 job would be set to 1.
• B、 The lne_job1 job would be executed synchronously.
• C、 The lne_job1 job would run immediately in the users current session.
• D、 The lne_job1 job would retain its current priority.
• E、 The job will immediately take priority over all running jobs.

第15题：

Which of the following objects can be directly referenced by a window object？（）

• A、 Schedule object
• B、 Program object
• C、 Job object
• D、 Resource plan
• E、 Resource consumer group

第16题：

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）  

• A、 The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
• B、 The job affinity is to a service and one node in that service is unavailable.
• C、 The job affinity is to an instance and that instance is unavailable.
• D、 There is no service affinity.
• E、 None of the above.

第17题：

You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）

• A、 The command will be executed successfully.
• B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

第18题：

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？（）

• A、SWITCH_TIME
• B、SWITCH_GROUP
• C、MAX_SESS_POOL
• D、SWITCH_ESTIMATE

第19题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

• A、You should create a job which is assigned to the Database Maintenance category
• B、You should create an Alert which will run another to delete the maintenance job.
• C、You should create a job. You schedule the job to run only once.
• D、You should create a job. The job uses the Automatically delete job option

第20题：

第21题：

第22题：

第23题：