Which two are true? (Choose two.)

The correct answer is A. ADD_MONTHS adds a number of calendar months to a date. C. CEIL returns the largest integer less than or equal to a specified number. https://docs.oracle.com/database/121/SQLRF/functions025.htm https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions004.htm

Using Single-Row Functions to Customize Output

Question

Options

AADD_MONTHS adds a number of calendar months to a date.
BCEIL requires an argument which is a numeric data type.
CCEIL returns the largest integer less than or equal to a specified number.
DLAST_DAY returns the date of the last day of the current month only.
ELAST_DAY returns the date of the last day of the month for the date argument passed to the
FLAST_DAY returns the date of the last day of the previous month only.

How the community answered

(39 responses)

A
72% (28)
B
5% (2)
D
15% (6)
E
5% (2)
F
3% (1)

Explanation

https://docs.oracle.com/database/121/SQLRF/functions025.htm https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions004.htm

Topics

#ADD_MONTHS#CEIL function#LAST_DAY function#date and numeric functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice