网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
Which three statements are true about windows?()
A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQLBEGINDBMS_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=’LOWJOBPRIORITYCLASS’）；END；SQL/Whatwillbetheresultoftheabovecommand？（）A.Thecommandwillbeexecutedsuccessfully.B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
考题
Which of the following objects can be directly referenced by a window object? ()
A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer group
考题
Which three statements are true about windows? ()(Choose three.)
A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
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 belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs
考题
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_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2
考题
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.
考题
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.
考题
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、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
Which of the following objects can be directly referenced by a window object？（）A、 Schedule objectB、 Program objectC、 Job objectD、 Resource planE、 Resource consumer group
考题
Which three statements are true about windows? （）(Choose three.)A、Only one window can be open at any given timeB、Consumer groups are associated with windowsC、Windows work with job classes to control resource allocationD、The database service name must be provided during windows creationE、Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
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.
考题
Which three statements are true about windows？（） A、 Only one window can be open at any given timeB、 Consumer groups are associated with windowsC、 Windows work with job classes to control resource allocationD、 The database service name must be provided during windows creationE、 Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
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.
考题
Which two statements are true about a job chain？（）A、 A job chain can contain a nested chain of jobsB、 The jobs in a job chain cannot have more than one dependencyC、 A job of the CHAIN type can be run using event-based or time-based schedulesD、 The jobs in a job chain can be executed only by using the events generated by the Scheduler
考题
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_TIMEB、SWITCH_GROUPC、MAX_SESS_POOLD、SWITCH_ESTIMATE
考题
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 belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs
考题
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 categoryB、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
考题
多选题Which two statements are true about a job chain？（）AA job chain can contain a nested chain of jobsBThe jobs in a job chain cannot have more than one dependencyCA job of the CHAIN type can be run using event-based or time-based schedulesDThe jobs in a job chain can be executed only by using the events generated by the Scheduler
考题
单选题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.
考题
单选题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_MTHB
NEW_CPU_MTHC
CPU_P1D
CPU_P2
考题
单选题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 categoryB
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
考题
多选题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？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE
考题
单选题You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）A
Implement job classesB
Implement Scheduler windowsC
Implement the mapping rule for the consumer groupsD
Set the SWITCH_TIME resource plan directive for both the resource plans
考题
单选题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 plan PROD_DB_PLAN can have subplans.B
The members of the HIGH_CG consumer group would get 10% of the CPU.C
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.D
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.
考题
单选题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.
考题
多选题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?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
热门标签
最新试卷