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
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
相关考题:
It has been over a century _______ the railway was completed. (A)when(B) once(C) which(D) since
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.
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’);
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.
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? () A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTE
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)
The beautiful mountain village__________ we spent our holiday last year is locatedin __________ is now part of Guangxi.A.which ; whereB.where; whatC.that ; whatD.when ; which
【单选题】DATEDIF函数返回两个日期之间的年月日间隔数,其一般形式为:DATEDIF(start_date,end_date,unit),unit参数不可以是()。A.YB.MC.DD.YMD