Management has asked you to calculate the value 12* salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCHAR2 (35) NOT NULL SALARY NUMBER (9, 2) NOT NULL COMMISSION_PCT NUMBER (4, 2) Which statement ensures that a value is displayed in the calculated column for all employees? | Oracle

A. SELECT last_name, 12 * salary* commission_pct FROM emp;
B. SELECT last_name, 12 * salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12 * salary* (nvl(commission_pct,0) FROM emp;
D. SELECT last_name, 12 * salary* (decode(commission_pct,0)) FROM emp;

Ans:C