多选题When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）AThe job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEBThe job will only be disabled if the value of the AUTO_DROP att

题目
多选题
When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）
A

The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE

B

The job will only be disabled if the value of the AUTO_DROP attribute is FALSE

C

The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE

D

All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE

E

The STATE column of the job table will be set to COMPLETED for the job

相似考题

1.The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.

2.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?()A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEB. The job will only be disabled if the value of the AUTO_DROP attribute is FALSEC. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSED. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUEE. The STATE column of the job table will be set to COMPLETED for the job

3.If a job references a schedule that has been disabled, what will be the result?()A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object cannot be disabled.

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

更多“多选题When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）AThe job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEBThe job will only be disabled if the value of the AUTO_DROP att”相关问题

  • 第1题：

    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

  • 第2题：

    Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? ()

    A. SET_ATTRIBUTE_NULL

    B. ALTER_JOB

    C. ALTER_JOB_PARAMETERS

    D. ALTER

    E. SET_ATTRIBUTE


    参考答案：A, E

  • 第3题：

    The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command? ()(Choose two.)

    A. The job is enabled by default after creation

    B. The job is automatically dropped after the end date

    C. The job executes with the privileges of the user SYS

    D. The globalization environment that exists at the time of the job creation prevails at the job runs


    参考答案：B, C

  • 第4题：

    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

  • 第5题：

    If a job references a schedule that has been disabled， what will be the result？（）  

    • A、 The job will be automatically disabled.
    • B、 The job will never execute.
    • C、 The job will attempt to execute but will fail.
    • D、 The job will inherit the DEFAULT_SCHEDULE schedule.
    • E、 A schedule object cannot be disabled.

    正确答案:E

  • 第6题：

    When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）

    • A、SET_JOB_ARGUMENT_VALUE
    • B、SET_JOB_VALUE_ANYDATA
    • C、SET_JOB_ANYDATA_VALUE
    • D、SET_SPECIAL_JOB_VALUE
    • E、SET_JOB_ANYTYPE_VALUE

    正确答案:C

  • 第7题：

    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

    • A、 The code will be executed successfully.
    • B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
    • C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
    • D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.

    正确答案:C

  • 第8题：

    单选题
    If a job references a schedule that has been disabled, what will be the result?（）
    A

    The job will be automatically disabled.

    B

    The job will never execute.

    C

    The job will attempt to execute but will fail.

    D

    The job will inherit the DEFAULT_SCHEDULE schedule.

    E

    A schedule object cannot be disabled.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    When setting arguments for a job， which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype？（）
    A

     SET_JOB_ARGUMENT_VALUE

    B

     SET_JOB_VALUE_ANYDATA

    C

     SET_JOB_ANYDATA_VALUE

    D

     SET_SPECIAL_JOB_VALUE

    E

     SET_JOB_ANYTYPE_VALUE


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

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


    正确答案： D,A
    解析： 暂无解析

  • 第12题：

    单选题
    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）
    A

     The code will be executed successfully.

    B

     The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.

    C

     The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.

    D

     The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    What is the default value for the ENABLED attribute of a job or program when it is created? ()

    A. TRUE

    B. FALSE

    C. There is no default. It must be defined at creation time.

    D.PENDING

    E. NULL


    参考答案：B

  • 第14题：

    When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()

    A. SET_JOB_ARGUMENT_VALUE

    B. SET_JOB_VALUE_ANYDATA

    C. SET_JOB_ANYDATA_VALUE

    D. SET_SPECIAL_JOB_VALUE

    E. SET_JOB_ANYTYPE_VALUE


    参考答案：C

  • 第15题：

    What is the default value for the ENABLED attribute of a job or program when it is created? （）

    • A、TRUE
    • B、FALSE
    • C、There is no default. It must be defined at creation time.
    • D、PENDING
    • E、NULL

    正确答案:B

  • 第16题：

    When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）

    • A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
    • B、The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
    • C、The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
    • D、All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
    • E、The STATE column of the job table will be set to COMPLETED for the job

    正确答案:A,B,E

  • 第17题：

    Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）

    • A、 SET_ATTRIBUTE_NULL
    • B、 ALTER_JOB
    • C、 ALTER_JOB_PARAMETERS
    • D、 ALTER
    • E、 SET_ATTRIBUTE

    正确答案:A,E

  • 第18题：

    You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）

    • A、 The member jobs would get dropped when the job class is dropped.
    • B、 Both the jobs would be executed concurrently.
    • C、 The member jobs would get disabled when the job class is dropped.
    • D、 The attributes defined at the class level would be applied to both the jobs.
    • E、 Jobs in the job class must have been assigned the same priority.

    正确答案:C,D

  • 第19题：

    Which of the following tasks is not performed by the job coordinator?（）

    • A、Update job log when a job completes
    • B、Spawn and remove job slaves
    • C、Write/read job info to/from memory cache
    • D、Query job table
    • E、Pass job information to job slaves

    正确答案:A

  • 第20题：

    单选题
    When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）
    A

    SET_JOB_ARGUMENT_VALUE

    B

    SET_JOB_VALUE_ANYDATA

    C

    SET_JOB_ANYDATA_VALUE

    D

    SET_SPECIAL_JOB_VALUE

    E

    SET_JOB_ANYTYPE_VALUE


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Which of the following tasks is not performed by the job coordinator?（）
    A

    Update job log when a job completes

    B

    Spawn and remove job slaves

    C

    Write/read job info to/from memory cache

    D

    Query job table

    E

    Pass job information to job slaves


    正确答案： E
    解析： 暂无解析

  • 第22题：

    多选题
    Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）
    A

    SET_ATTRIBUTE_NULL

    B

    ALTER_JOB

    C

    ALTER_JOB_PARAMETERS

    D

    ALTER

    E

    SET_ATTRIBUTE


    正确答案： A,C
    解析： 暂无解析

  • 第23题：

    多选题
    When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）
    A

    The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE

    B

    The job will only be disabled if the value of the AUTO_DROP attribute is FALSE

    C

    The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE

    D

    All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE

    E

    The STATE column of the job table will be set to COMPLETED for the job


    正确答案： A,C
    解析： 暂无解析

  • 第24题：

    多选题
    You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）
    A

    The member jobs would get dropped when the job class is dropped.

    B

    Both the jobs would be executed concurrently.

    C

    The member jobs would get disabled when the job class is dropped.

    D

    The attributes defined at the class level would be applied to both the jobs.

    E

    Jobs in the job class must have been assigned the same priority.


    正确答案： A,E
    解析： 暂无解析

相关内容