WHAT VALUE IS RETURNED AFTER EXECUTING THE FOLLOWING STATEMENT

9. What value is returned after executing the following statement?

SELECT NVL2(NULLIF('CODA', 'SID'), 'SPANIEL', 'TERRIER')

FROM DUAL;

(Choose the best answer.)

A. SPANIEL

B. TERRIER

C. NULL

D. None of the above