Oracle OCP 1Z0 053 Q447(Schedule&BYMONTHDAY)
447.Which of the following calendaring syntax expressions would evaluate to the last day of every month?
A. FREQ = MONTHLY; BYMONTHDAY = 31
B. FREQ = MONTHLY; BYMONTHDAY = -1
C. FREQ = DAILY; BYDAY = -1
D. FREQ = MONTHLY; BYDAY = 31
E. FREQ = DAILY; BYMONTHDAY = LAST_DAY
Answer: B
记住last day of every month是用-1表示的，而不是LAST_DAY
参考：http://blog.csdn.net/rlhua/article/details/15499477
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12676
A. FREQ = MONTHLY; BYMONTHDAY = 31
B. FREQ = MONTHLY; BYMONTHDAY = -1
C. FREQ = DAILY; BYDAY = -1
D. FREQ = MONTHLY; BYDAY = 31
E. FREQ = DAILY; BYMONTHDAY = LAST_DAY
Answer: B
记住last day of every month是用-1表示的，而不是LAST_DAY
参考：http://blog.csdn.net/rlhua/article/details/15499477
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12676
Run on the last day of every month.
FREQ=MONTHLY; BYMONTHDAY=-1;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2074510/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
