违法和不良信息举报 联系客服
免费注册 登录

多选题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 whi

题目
多选题
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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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


参考答案：B, C

第2题：

You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

  • A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
  • B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
  • C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
  • D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

正确答案:D

第3题：

Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQL>BEGINDBMS_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.


参考答案：E

第4题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

  • A、The DBMS_JOB package
  • B、The BACKUP_JOB package
  • C、The DBMS_BACKUP_RESTORE package
  • D、The calendar tool in the Operating System （OS）
  • E、The backup scheduler in Enterprise Manager （EM）
  • F、The DBMS_BACKUP_SCHEDULER packager inline mode

正确答案:E

第5题：

Which view will you use to view information regarding the jobs that are currently running in a database？（）

  • A、DBA_SCHEDULER_RUNNING_JOBS
  • B、DBA_SCHEDULER_JOB_RUN_DETAILS
  • C、DBA_SCHEDULER_JOBS
  • D、DBA_SCHEDULER_JOB_LOG

正确答案:A

第6题：

While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）

  • A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
  • B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
  • C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
  • D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

正确答案:A

第7题：

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.

正确答案:A

第8题：

Which two statements are true about a job chain? ()(Choose two.)

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


参考答案：A, C

第9题：

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

正确答案:A,C

第10题：

Which two statements are true about a job chain? （）(Choose two.)

  • 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

正确答案:A,C

更多相关问题
相关内容