Oracle
1Z0-071 · Question #440
1Z0-071 Question #440: Real Exam Question with Answer & Explanation
The correct answer is D. COALESCE stops evaluating the list of expressions when it finds the first non-null value. E. The first expression in NVL2 is never returned.. See the full explanation below for the reasoning.
Question
Which two are true about the NVL, NVL2, and COALESCE functions? (Choose two.)
Options
- ANVL must have expressions of the same data type.
- BNVL can have any number of expressions in the list.
- CNVL2 can have any number of expressions in the list.
- DCOALESCE stops evaluating the list of expressions when it finds the first non-null value.
- EThe first expression in NVL2 is never returned.
- FCOALESCE stops evaluating the list of expressions when it finds the first null value.
Community Discussion
No community discussion yet for this question.