Oracle Exam 1Z0-071 Topic 2 Question 51 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 51
Topic #: 2

In your session NLS_ DATE_ FORMAT is set to DD--MON_RR.

Which two queries display the year as four digits?

ASELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

BSELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

CSELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

DSELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

ESELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

FSELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

Show Suggested Answer

Suggested Answer: E, F

by Casie at May 05, 2022, 07:32 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!