Exam 1z0-082 topic 1 question 123 discussion

Actual exam question from Oracle's 1z0-082

Question #: 123
Topic #: 1

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?

A. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <=25
D. WHERE TO_NUMBER(start date - SYSDATE) <= 25

Show Suggested Answer

Suggested Answer: A 🗳️

by ivanadj at Feb. 14, 2023, 2:04 p.m.

Comments

Submit Cancel

Jinas

10 months, 1 week ago

C is correct

upvoted 1 times

...

auwia

11 months, 3 weeks ago

Selected Answer: C

Provided answer is wrong. C is correct. -- Creating the table CREATE TABLE STORES ( ID NUMBER, NAME VARCHAR2(50), START_DATE DATE ); -- Inserting data into the table INSERT INTO STORES VALUES (1, 'Store 1', SYSDATE); INSERT INTO STORES VALUES (2, 'Store 2', ADD_MONTHS(SYSDATE, -10)); INSERT INTO STORES VALUES (3, 'Store 3', ADD_MONTHS(SYSDATE, -20)); INSERT INTO STORES VALUES (4, 'Store 4', ADD_MONTHS(SYSDATE, -30)); -- Commit to save data COMMIT; -- Selecting rows where START_DATE is within the last 25 months SELECT * FROM STORES WHERE MONTHS_BETWEEN(SYSDATE, START_DATE) <= 25;

upvoted 1 times

...