Oracle Exam 1Z0-082 Topic 14 Question 84 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 84
Topic #: 14

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?

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

Show Suggested Answer

Suggested Answer: A, B, C

https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/

by Jaclyn at Dec 27, 2023, 09:47 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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

Kayleigh

No problem, happy to help with SQL queries!

upvoted 0 times

...

Noemi

1 days 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

...