Q
What does COALESCE(a, b, c) return?
-
A
The last non-NULL value
-
B
The first non-NULL value among its arguments
-
C
The sum of non-NULL values
-
D
Always the first argument
Correct Answer:
B. The first non-NULL value among its arguments
Explanation:
COALESCE can take many arguments, unlike NVL, which takes two.
