Oracle
1Z0-082 · Question #117
1Z0-082 Question #117: Real Exam Question with Answer & Explanation
The correct answer is D. WHERE MON'THS_BETWEEN (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 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
Community Discussion
No community discussion yet for this question.