Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 207

You need to calculate the number of days from 1st January 2019 until today.

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output? (Choose two.)

SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM

SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

SELECT ROUND(SYSDATE – TO_DATE('01/JANUARY/2019')) FROM DUAL;

SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

Correct Answer: B, E

To calculate the number of days between SYSDATE and a specific date in Oracle SQL, you need to use the correct date format and functions. Option B is correct since SYSDATE is already a date type, and subtracting a date string from it properly in the format 'DD-MON-YYYY' will give the number of days. However, it needs to be enclosed in parentheses and 'DUAL' table is required for execution. Option E is also correct as it correctly transforms the string date '01-JANUARY-2019' into a date using TO_DATE function and then subtracts it from SYSDATE to return the number of days.

Discussion

Misi_OracleOptions: CE

C is correct if you change the - operator between sysdate and to_date manually. i think there is a mistake.

NB196

https://www.examtopics.com/discussions/oracle/view/20180-exam-1z0-071-topic-2-question-44-discussion/

yaya32Option: E

The only working query is E all of the others are not working.