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 143 discussion

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

The ORDERS table has a column ORDER_DATE of data type DATE.

The default display format for a date is DD-MON-RR.

Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

  • A. WHERE order_date > TO_DATE(‘JUL 10 2018’, ‘ MON DD YYYY’)
  • B. WHERE order_date > TO_DATE(ADD_MONTH(SYSDATE, 6), ‘MON DD YYYY’)
  • C. WHERE order_date IN (TO_DATE(‘Oct 21 2018’, ‘Mon DD YYYY’), TO_CHAR(‘Nov 21 2018’, ‘Mon DD YYYY’))
  • D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), ‘MON DD YYYY’)
  • E. WHERE TO_CHAR(order_date. ‘MON DD YYYY’) = ‘JAN 20 2019’
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by kesammy9 at Feb. 23, 2023, 9:27 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
Thameur01
3 months, 1 week ago
Selected Answer: AE
in E there is a mistake and should be "," instead of ".", the E should be correct answer.
upvoted 1 times
...
kay000001
5 months, 3 weeks ago
Selected Answer: AE
Answers are: A & E - both tested.
upvoted 1 times
...
ArslanAltaf
10 months, 2 weeks ago
A & D is correct. below works select * from emp WHERE hire_date > To_Char(ADD_MONTHS(SYSDATE, 6), 'dd mm yyyy');
upvoted 2 times
zzz02
7 months ago
agree on that one
upvoted 1 times
...
...
ArslanAltaf
10 months, 2 weeks ago
E is wrong. the string in quotes seems like a date after = but DB will only consider it as a string, not a date.
upvoted 1 times
...
yaya32
1 year, 3 months ago
Selected Answer: AE
I thin AE is correct
upvoted 1 times
...
lucemqy
1 year, 5 months ago
Selected Answer: AE
AE correct
upvoted 1 times
...
Darnun
2 years ago
Selected Answer: AE
Only A works. Assuming that in E there is a mistake and should be "," instead of ".", the E should be correct answer.
upvoted 1 times
zouve
1 year, 9 months ago
also in B the function ADD_MONTH is wrong it must be ADD_MONTHS
upvoted 1 times
...
...
kesammy9
2 years, 1 month ago
Selected Answer: AE
checked
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago