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

Johnathon

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

...

Niesha

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

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

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

...