Exam 1z0-071 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-071

Question #: 34
Topic #: 1

[All 1z0-071 Questions]

Which three queries execute successfully? (Choose three.)

A. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;
B. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;
C. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;
D. SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;
E. SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;
F. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

Show Suggested Answer

Suggested Answer: BDE 🗳️

by J4vi at May 8, 2023, 1:09 a.m.

Comments

Submit Cancel

826cb95

5 days, 22 hours ago

Selected Answer: ABD

A is also right why?... ✅ A. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL; Valid: Oracle allows arithmetic with dates and numbers. 1 - SYSDATE gives a negative number (interval), and subtracting another DATE results in a valid numeric result. ✅ Executes successfully

upvoted 1 times

...

TheOracleWasTaken

1 year, 2 months ago

Selected Answer: BDE

I am assuming it is supposed to be to_date

upvoted 2 times

ArslanAltaf

6 months, 1 week ago

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

upvoted 1 times

...

J4vi

1 year, 5 months ago

Selected Answer: BDE

Tried all the alternatives

upvoted 4 times

...

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam