Question $40$

The PRODUCT table contains these columns:

PRODUCT$\_$ID NUMBER$(9)$

DESCRIPTION VARCHAR$2(20)$

COST NUMBER$(5,2)$

MANUFACTURER$\_$ID VARCHAR$2(10)$

QUANTITY NUMBER$(5)$

Evaluate these two statements:

Statement $1$

SELECT NVL$(100/$ quantity, 'none'$)$

FROM PRODUCT;

Statement $2$

SELECT NVL$($TO$\_$CHAR$($quantity$),$ 'none'$)$

FROM PRODUCT;

Which statement is TRUE?

A$.$

Both statements execute successfully.

B$.$

Statement $1$ may fail because the data types are incompatible.

C$.$

Statement $2$ causes an error when QUANTITY values are null.

D$.$

Statement $1$ executes but does not display the value 'none' for null values.