View the Exhibit and examine the description of the EMPLOYEES table. You want to
calculate the total remuneration for each employee. Total remuneration is the sum of the
annual salary and the percentage commission earned for a year. Only a few employees
earn commission. Which SOL statement would you execute to get the desired output?
A.
SELECTfirst_name, salary, salary*12+salary*commission_pct “Total” FROM
EMPLOYEES;
B.
SELECTfirst_name, salary, salary*12+NVL((salary*commission_pct), 0) “Total” FROM
EMPLOYEES;
C.
SELECTfirst_name, salary, salary*12 + NVL(salary, O)*commission_pct “Total” FROM
EMPLOYEES;
D.
SELECTfirst_name, salary, salary*12+(salary*NVL2(commission_pct,
salary,salary+commission_pct))”Total” FROM EMPLOYEES;