Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-082 Topic 14 Question 84 Discussion

Actual exam question for Oracle's 1Z0-082 exam
Question #: 84
Topic #: 14
[All 1Z0-082 Questions]

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?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Malika
1 months ago
I bet the person who wrote this question is the same one who came up with 'SELECT DISTINCT * FROM table'.
upvoted 0 times
...
Paola
1 months ago
I'm just glad we don't have to use the ancient DATEDIFF function. That always gives me a headache.
upvoted 0 times
Jimmie
6 days ago
D) WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
upvoted 0 times
...
Wenona
14 days ago
B) WHERE ADD_MONTHS
upvoted 0 times
...
Rusty
19 days ago
A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
upvoted 0 times
...
...
Dortha
2 months ago
Option C looks like it's trying to do the same thing, but the syntax is a bit off. It's not going to work as written.
upvoted 0 times
Caprice
29 days ago
D) WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
upvoted 0 times
...
Jacki
1 months ago
B) WHERE ADD_MONTHS
upvoted 0 times
...
Dominque
1 months ago
A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
upvoted 0 times
...
...
Johnathon
2 months ago
I like how option B uses the ADD_MONTHS function to achieve the same result. It's a different approach, but equally valid.
upvoted 0 times
Noemi
22 hours ago
I think I'll go with option B for my query, thanks for pointing it out.
upvoted 0 times
...
Deeanna
3 days ago
Yes, it's a nice alternative to the traditional MONTHS_BETWEEN approach.
upvoted 0 times
...
Leontine
4 days ago
I agree, option B is a clever use of the ADD_MONTHS function.
upvoted 0 times
...
Moon
10 days ago
D) WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
upvoted 0 times
...
Jettie
12 days ago
C) WHERE TO_XUMBER(start_date - SYSDATE) <= 25
upvoted 0 times
...
Shelton
14 days ago
C) WHERE TO_XUMBER(start_date - SYSDATE) <= 25
upvoted 0 times
...
Rebecka
18 days ago
B) WHERE ADD_MONTHS
upvoted 0 times
...
Donette
19 days ago
B) WHERE ADD_MONTHS
upvoted 0 times
...
Tresa
1 months ago
A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
upvoted 0 times
...
Eulah
2 months ago
A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
upvoted 0 times
...
...
Niesha
2 months ago
Option D is the correct answer. The MONTHS_BETWEEN function calculates the number of months between two dates, and we want the rows where this value is less than or equal to 25.
upvoted 0 times
...
Alonso
2 months ago
That makes sense, but I still think A) is correct because it compares the current date with the start date to find rows within the last 25 months.
upvoted 0 times
...
Polly
2 months ago
I disagree, I believe the answer is D) WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25 because it calculates the months between the start date and current date.
upvoted 0 times
...
Alonso
2 months ago
I think the correct answer is A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25.
upvoted 0 times
...
Kayleigh
2 months ago
Hmm, I see your point. Let's discuss it further to understand the rationale behind each option.
upvoted 0 times
...
Aron
2 months ago
I disagree, I believe the correct answer is D) WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
upvoted 0 times
...
Kayleigh
2 months ago
I think the answer is A) WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
upvoted 0 times
...

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77