itgle.com

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 at

题目
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.It has been over a century _______ the railway was completed.(A)when(B) once(C) which(D) since

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.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’）；

4.[A] which [B] that [C] what [D] when

参考答案和解析
参考答案：A, B, E
更多“When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?() ”相关问题

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

    Examine the description of the STUDENTS table:Which two aggregate functions are valid on the START_DATE column?()

    A. SUM(start_date)

    B. AVG(start_date)

    C. COUNT(start_date)

    D. AVG(start_date, end_date)

    E. MIN(start_date)

    F. MAXIMUM(start_date)


    参考答案：C, E

  • 第3题：

    The beautiful mountain village__________ we spent our holiday last year is locatedin __________ is now part of Guangxi.

    A.which ; where
    B.where; what
    C.that ; what
    D.when ; which

    答案：B
    解析：
    where在此充当地点状语，what既充当located in的宾语又充当is的主语，本题考查定语从句和名词性从句。mountain village在定语从句we spent our holiday last year作地点状语，故用关系副词where：第二个考查宾语从句，从句中缺少主语，故用what作主语。故选B。

  • 第4题：

    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

  • 第5题：

    [A] who [B] when [C] where [D] which


    正确答案：C

  • 第6题：

    【单选题】DATEDIF函数返回两个日期之间的年月日间隔数，其一般形式为：DATEDIF（start_date,end_date,unit)，unit参数不可以是（）。

    A．Y

    B．M

    C．D

    D．YMD


    D

相关内容