Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 1 of 50

Marks: +1, -0

You need to display the date 11-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’.
Which SQL statement would give the required result?

SELECT TO_CHAR (TO_DATE (’11-oct-2007’), ‘fmDdthsp “of” Month, Year’)
FROM DUAL
SELECT TO_CHAR (‘11-oct-2007’, ‘fmDdspth “of” Month, Year’)
FROM DUAL
SELECT TO_CHAR (TO_DATE (‘11-oct-2007’), ‘fmDdspth of month, year’)
FROM DUAL
SELECT TO_DATE (TO_CHAR (’11-oct-2007’), ‘fmDdspth “of” Month, Year’))
FROM DUAL

Go to Question:

Next Question