Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Oracle Discussions

Exam 1z0-071 topic 1 question 86 discussion

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

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
FROM DUAL;

What is the result?

  • A. It executes successfully but does not return any result.
  • B. It returns the date for the first Monday of the next month.
  • C. It returns the date for the last Monday of the current month.
  • D. It generates an error.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by zangado at Dec. 5, 2023, 7:53 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
ArslanAltaf
1 week, 6 days ago
B correct. D is wrong. output is "06 Monday for May 2024"
upvoted 1 times
...
deepzsiva
3 months, 1 week ago
Selected Answer: B
Answer is B. Tested.
upvoted 3 times
...
zangado
4 months, 3 weeks ago
Selected Answer: D
There should be 'Monday' instead of 'MON'
upvoted 2 times
ogi33
3 weeks ago
The argument char must be a day of the week in the date language of your session, either the full name or the abbreviation https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NEXT_DAY.html#GUID-01B2CC7A-1A64-4A74-918E-26158C9096F6
upvoted 1 times
...
zibby92
4 months, 2 weeks ago
https://www.examtopics.com/discussions/oracle/view/27077-exam-1z0-082-topic-1-question-86-discussion/ It works fine
upvoted 2 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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