Oracle Exam 1Z0-071 Topic 1 Question 104 Discussion

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

Question #: 104
Topic #: 1

[All 1Z0-071 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?

AWHERE MONTHS_ BETWEEN (SYSDATE, start_ date) <= 25

BWHERE MONTHS_ BETWEEN (start_ date, SYSDATE) <= 25

CWHERE TO_ NUMBER (start_ date - SYSDATE) <= 25

DWHERE ADD_ MONTHS (start_ date, 25) <= SYSDATE

Show Suggested Answer

Suggested Answer: A

by Robt at Sep 17, 2024, 04:02 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Marge

6 months ago

B is the way to go. Nice and simple, no need to get too fancy with the math.

upvoted 0 times

Lucina

5 months ago

B is the clear winner here, no need to overcomplicate things.

upvoted 0 times

...

Annmarie

5 months ago

I think B is the most efficient way to filter the rows.

upvoted 0 times

...

Gennie

6 months ago

Yeah, B seems like the most straightforward choice.

upvoted 0 times

...

Ryan

6 months ago

I agree, B is definitely the simplest option.

upvoted 0 times

...

Peter

6 months ago

I'd go with D. Adding 25 months to the start_date and comparing to SYSDATE is an interesting approach.

upvoted 0 times

Ellen

6 months ago

User1: Let's go with D then.

upvoted 0 times

...

Frederic

6 months ago

User2: Yeah, I agree. Adding 25 months to the start_date and comparing to SYSDATE makes sense.

upvoted 0 times

...

Deja

6 months ago

I think D is the correct option.

upvoted 0 times

...

Daren

7 months ago

I'm not sure, but I think D is the most logical choice.

upvoted 0 times

...

Tora

7 months ago

I agree with Wade, using ADD_MONTHS function makes sense.

upvoted 0 times

...

Wade

7 months ago

I think the correct answer is D.

upvoted 0 times

...

Truman

7 months ago

Definitely B. It's the most straightforward way to check if the date is within the last 25 months.

upvoted 0 times

...

Loreta

7 months ago

I was thinking C, but B makes more sense. Calculating the difference in months is a cleaner approach.

upvoted 0 times

Aileen

7 months ago

Yeah, B seems like the most logical choice here. It's important to accurately calculate the months between the dates.

upvoted 0 times

...

Lashaunda

7 months ago

I agree, B is the way to go. It's a straightforward way to filter the rows based on the date criteria.

upvoted 0 times

...

Gianna

7 months ago

I think B is the correct answer. It compares the start date to the current date and checks if it's within the last 25 months.

upvoted 0 times

...

Leanora

8 months ago

Option B looks good to me. Using MONTHS_BETWEEN with the start_date and SYSDATE seems like the right way to go.

upvoted 0 times

Whitley

7 months ago

Rosalind: Let's go with option B then.

upvoted 0 times

...

Chantay

7 months ago

Yeah, that's the way to go to display details within the last 25 months.

upvoted 0 times

...

Rosalind

7 months ago

I agree, using MONTHS_BETWEEN with start_date and SYSDATE makes sense.

upvoted 0 times

...

Meaghan

7 months ago

I think option B is the correct one.

upvoted 0 times

...