Oracle Database 12c SQL 1z0-071 Question # 73 Topic 8 Discussion

Oracle Database 12c SQL 1z0-071 Question # 73 Topic 8 Discussion

1z0-071 Exam Topic 8 Question 73 Discussion:
Question #: 73
Topic #: 8

Which three queries execute successfully?


A.

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


B.

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


C.

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


D.

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


E.

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


F.

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


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.