Oracle
1Z0-082 · Question #117
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…
The correct answer is D. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
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?
Options
- AWHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
- BWHERE ADD_MONTHS<start_date, 25) <= SYSDATE
- CWHERE TO_XUMBER(start_date - SYSDATE) <= 25
- DWHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- C4% (1)
- D82% (23)
Topics
#MONTHS_BETWEEN#date filtering#WHERE clause#date functions
Community Discussion
No community discussion yet for this question.