Oracle Database SQL — Question 1

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_DATE is within the last 25 months.
Which WHERE clause can be used?

Answer options

• A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25
• B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
• C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
• D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE

Correct answer: C

Explanation

The correct answer is C because it calculates the number of months between the current date (SYSDATE) and the START_DATE, checking if it is 25 months or less. Option A is incorrect as it improperly uses TO_NUMBER on the date difference, and Option B reverses the logic, which gives months in the future rather than past. Option D checks if the START_DATE plus 25 months is less than or equal to SYSDATE, which is not the requirement.