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
Consider the following code snippet: 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 user‟s current session. D. The lne_job1 job would retain its current priority. E. The job will immediately take priority over all running jobs.
A.It is executed first in the query execution B.It must be the last clause in the SELECT statement C.It cannot be used in a SELECT statement containing a HAVING clause D.You cannot specify a column name followed by an expression in this clause E.You can specify a combination of numeric positions and column names in this clause