Oracle
1Z0-071 · Question #425
Which three queries execute successfully? (Choose three.)
The correct answer is B. 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. See the full explanation below for the reasoning.
Question
Which three queries execute successfully? (Choose three.)
Options
- ASELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;
- BSELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;
- CSELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;
- DSELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;
- ESELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;
- FSELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;
How the community answered
(28 responses)- A11% (3)
- B82% (23)
- C4% (1)
- F4% (1)
Community Discussion
No community discussion yet for this question.