Examice

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

Go to Exam

Question 34

Which three queries execute successfully? (Choose three.)

SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;

SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;

SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;

SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;

SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

Correct Answer: B, D, E

The query in option B is valid because subtracting a date from SYSDATE and then subtracting 1 is a valid operation. Option D is also correct because it similarly involves valid date arithmetic. Option E is correct because dividing the result of date subtraction by 1 is valid. However, options A, C, and F involve invalid operations such as subtracting and dividing SYSDATE by non-date values directly, which would result in errors.

Discussion

J4viOptions: BDE

Tried all the alternatives

TheOracleWasTakenOptions: BDE

I am assuming it is supposed to be to_date

ArslanAltaf

it worked in 19c exactly like below syntax SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL