Oracle Exam 1Z0-071 Topic 8 Question 8 Discussion

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

Question #: 8
Topic #: 8

[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 ADD_MONTHS (3tart_datO, 25) <= SYSDATE

CWHERE MONTHS_UETWEEN (start_date, SYSDATE) <= 25

DWHERE TO_NUMBER (start_date - SYSDATE) <= 25

Show Suggested Answer

Suggested Answer: A

by Cordelia at May 06, 2022, 03:07 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!