Oracle
1Z0-071 · Question #414
1Z0-071 Question #414: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #414. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.