Exam 1z0-061 topic 3 question 7 discussion

Actual exam question from Oracle's 1z0-061

Question #: 7
Topic #: 3

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

A. SELECT TO_CHAR(TO_DATE('19-Mar-2001, DD-Mon-YYYY), fmDdspth "of" Month YYYY fmHH:MI:SS AM’) NEW_DATE . FROM dual;
B. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), Ddspth "of" Month YYYY fmHH:MI:SS AM’) NEW_DATE FROM dual;
C. SELECT TO_CHAR(TO_DATE(’19-Mar-2001’, ‘DD-Mon-YYYY’), ‘fmDdspth "of" Month YYYY HH:MI:SS AM) NEW_DATE FROM dual;
D. SELECT TO_CHAR(TO_DATE(’19-Mar-2001’, ‘DD-Mon-YYYY), ‘fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;

Show Suggested Answer

Suggested Answer: A 🗳️

by hggz at Sept. 21, 2019, 7:38 p.m.

Comments

Submit Cancel

qayaza

5 years, 2 months ago

D is the correct answer.

upvoted 1 times

...

bisiha

5 years, 4 months ago

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'),'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual; Correct answer

upvoted 2 times

...

Answer is correct, you can check what is difference: SELECT 1, TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual union SELECT 2, TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual union SELECT 3, TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual; Last - wrong syntax SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:HI:SS AM') NEW_DATE FROM dual;

upvoted 1 times

...

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam

Exam 1z0-061 topic 3 question 7 discussion

Comments

qayaza

bisiha

hggz

SY0-701