Oracle Database SQL — Question 251

Which two are true? (Choose two.)

Answer options

• A. ADD_MONTHS adds a number of calendar months to a date.
• B. CEIL requires an argument which is a numeric data type.
• C. CEIL returns the largest integer less than or equal to a specified number.
• D. LAST_DAY returns the date of the last day of the current month only.
• E. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
• F. LAST_DAY returns the date of the last day of the previous month only.

Correct answer: A, E

Explanation

Option A is correct because ADD_MONTHS is specifically designed to add a specified number of months to a date. Option E is also correct as LAST_DAY accurately returns the last day of the month for the date provided. Options B, C, D, and F are incorrect because B and C do not correctly describe the CEIL function, and D and F misrepresent the LAST_DAY function's behavior.