Oracle Database Administration I — Question 90

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 ADD_MONTHS(start_date, 25) <= SYSDATE
• B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
• C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <=25
• D. WHERE TO_NUMBER(start date - SYSDATE) <= 25

Correct answer: A

Explanation

The correct answer is A because it checks if the START_DATE plus 25 months is less than or equal to the current date, effectively filtering for rows added within the last 25 months. Option B is incorrect as it calculates the months between START_DATE and SYSDATE, which wouldn’t properly filter for recent entries. Option C reverses the logic, checking if the difference is within 25 months but will incorrectly include older dates. Option D uses an inappropriate method by trying to convert a date difference into a number, which does not yield the intended result.