ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 211 discussion

Actual exam question from Oracle's 1z0-071
Question #: 211
Topic #: 1
[All 1z0-071 Questions]

The SYSDATE function displays the current Oracle Server date as:

21-MAY-19


You wish to display the date as -


MONDAY, 21 MAY, 2019 -

Which statement will do this?

  • A. SELECT TO_DATE(SYSDATE, 'FMDAY, DD MONTH, YYYY') FROM DUAL;
  • B. SELECT TO_CHAR(SYSDATE, 'FMDD, DAY MONTH, YYYY') FROM DUAL;
  • C. SELECT TO_CHAR(SYSDATE, 'FMDAY, DD MONTH, YYYY') FROM DUAL;
  • D. SELECT TO_CHAR(SYSDATE, 'FMDAY, DDTH MONTH, YYYY') EROM DUAL;
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Orakol at Feb. 27, 2023, 3:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
zouve
1 year ago
C tested
upvoted 1 times
...
Orakol
1 year, 4 months ago
Selected Answer: C
Only 2 statements will be successfull: B - 27, MONTAG FEBRUAR, 2023 C - MONTAG, 27 FEBRUAR, 2023 Correct and needed answer is C.
upvoted 3 times
...
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.

SaveCancel