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
months_between.. The interval is important, and if I add 25 months to a date 3 years ago, it will not be in the desired interval... disregar my previous comment
C is true. MONTHS_BETWEEN(date 1, date 2) Oracle gives a positive value when date 1 > date 2 and a negative when date 1 < date 2
https://www.techonthenet.com/oracle/functions/months_between.php
Yes because if we try a date that is 30 months before, if we add 25 months it is still less than SYSDATE so the condition will result true. That's why C is the only alternative
upvoted 1 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Drexan
2 months, 2 weeks agoDrexan
2 months, 2 weeks agopercyosag
8 months, 2 weeks agoguretto
1 year, 2 months agoPuErh
1 year, 9 months agoTofOra
11 months, 2 weeks agoRik92
1 year, 8 months agoRik92
1 year, 7 months agodexdinh91
1 year, 12 months agoLATI2022
2 years, 2 months agoRik92
2 years, 2 months agomeddheddy
2 years, 3 months agokakamusili
2 years, 2 months agoPeter_Chen
2 years, 2 months agoAntreu
2 years, 2 months agozzsqlcoder
3 months, 3 weeks ago