Oracle
1Z0-071 · Question #414
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 A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25. See the full explanation below for the reasoning.
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 TO_NUMBER(start_date - SYSDATE) <= 25
- BWHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
- CWHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
- DWHERE ADD_MONTHS(start_date, 25) <= SYSDATE
How the community answered
(21 responses)- A76% (16)
- B5% (1)
- C10% (2)
- D10% (2)
Community Discussion
No community discussion yet for this question.