网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 ” 相关考题
考题
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 ; where
B.where; what
C.that ; what
D.when ; which
考题
【单选题】DATEDIF函数返回两个日期之间的年月日间隔数，其一般形式为：DATEDIF（start_date,end_date,unit)，unit参数不可以是（）。A．YB．MC．DD．YMD
热门标签
最新试卷