hiexam
oracle · 1z0-071 · Q603 · multiple_choice · topic_1

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to…

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?
  • A.WHERE TO_NUMBER(start_date - SYSDATE) <= 25
  • B.WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
  • C.WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
  • D.WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
Explanation
Selected Answer: C C is correct

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.