Oracle
1Z0-082 · Question #137
Which two queries execute successfully?
The correct answer is E. SELECT COALESCE(100, NULL, 200) FROM DUAL. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which two queries execute successfully?
Options
- ASELECT NULLIF(NULL, 100) FROM DUAL;
- BSELECT COALESCE (100, 'AM FROM DUAL;
- CSELECT 2TOLLIF(100, 'A') FROM DUAL;
- DSELECT NULLIF(100,100) FROM DUAL;
- ESELECT COALESCE(100, NULL, 200) FROM DUAL;
How the community answered
(37 responses)- A3% (1)
- B8% (3)
- C11% (4)
- D3% (1)
- E76% (28)
Topics
#NULLIF#COALESCE#NULL handling functions#single-row functions
Community Discussion
No community discussion yet for this question.