itgle.com

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.I'mnotsureaboutthemeaningoftheword.You'dbetterlookitupina____．A．letterB．dictionaryC．postcardD．notice

2.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.

3.Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob?()A.DBA_SCHEDULER_JOB_RUN_DETAILSB.DBA_SCHEDULER_RUNNING_JOBSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG

4.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

更多“You notice that the elapsed time for an important database scheduler Job is unacceptably l ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase?()

    A.DBA_SCHEDULER_RUNNING_JOBS

    B.DBA_SCHEDULER_JOB_RUN_DETAILS

    C.DBA_SCHEDULER_JOBS

    D.DBA_SCHEDULER_JOB_LOG


    参考答案：A

  • 第6题：

    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

相关内容