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

题目

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题：

Considerthefollowingcodesnippet:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE(name=>,,lne_job1,attribute=>,,job_priority,value=>1);END;／Ifthiscodewereexecuted,whichofthefollowingstatementswouldbetrue?()

A.Thepriorityofthelne_job1jobwouldbesetto1.

B.Thelne_job1jobwouldbeexecutedsynchronously.

C.Thelne_job1jobwouldrunimmediatelyintheuserscurrentsession.

D.Thelne_job1jobwouldretainitscurrentpriority.

E.Thejobwillimmediatelytakepriorityoverallrunningjobs.

参考答案：A

第2题：

Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?()

A.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，job_name=>’JOB1’）；

B.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，job_name=>’JOB_LOG’）；

C.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，which_log=>’JOB1’）；

D.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，which_log=>’JOB_LOG’）；

参考答案：D

第3题：

I'mnotsureaboutthemeaningoftheword.You'dbetterlookitupina____．

A．letter

B．dictionary

C．postcard

D．notice

正确答案：B

第4题：

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()

A. LOG_HISTORY

B. JOB_LOG_RETENTION

C. WINDOW_LOG_RETENTION

D. WHICH_LOG

E. LOG_NAME

参考答案：A, D

第5题：

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

第6题：

Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob?()

A.DBA_SCHEDULER_JOB_RUN_DETAILS

B.DBA_SCHEDULER_RUNNING_JOBS

C.DBA_SCHEDULER_JOBS

D.DBA_SCHEDULER_JOB_LOG

参考答案：C

第7题：

Youexecutedthefollowingcode:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE(NAME=>’JOB_A’,ATTRIBUTE=>’JOB_PRIORITY’,VALUE=>7);END;／Afteranalyzingtheabovecode,whatconclusionwillyoudraw?()

A.Thecodewillbeexecutedsuccessfully.

B.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustbe1，2，or3.

C.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustrangebetween1and5.

D.ThecodewillnotbeexecutedsuccessfullybecausenoSET_ATTRIBUTEprocedureexistsintheDBMS_SCHDULERpackage.

参考答案：C

第8题：

What's ( )job? Are ( ) British?

A. your, your

B. you, your

C. your, you

正确答案：C

第9题：

Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase?()

A.DBA_SCHEDULER_RUNNING_JOBS

B.DBA_SCHEDULER_JOB_RUN_DETAILS

C.DBA_SCHEDULER_JOBS

D.DBA_SCHEDULER_JOB_LOG

参考答案：A

第10题：

Which Scheduler view(s) can be queried to see which jobs are currently executing? ()

A. DBA_SCHEDULER_JOB_RUN_DETAILS

B. DBA_SCHEDULER_RUNNING_JOBS DBA

C. DBA_SCHEDULER_CURRENT_JOBS

D. DBA_SCHEDULER_JOBS DBA

E. DBA_SCHEDULER_EXECUTING_JOBS

参考答案：B, D

You notice that the elapsed time for an important database scheduler Job is unacceptably l

题目

相似问题和答案

相关内容