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;
The same question as question 10 in 1z0-071. The answer is C.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Jinas
5 months, 1 week agoauwia
6 months, 4 weeks agofdelasie
8 months agoDragon67
8 months, 2 weeks agoivanadj
11 months, 2 weeks agoivanadj
11 months, 3 weeks ago