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…

Question

Exhibit

Options

• ASELECTfirst_name, salary, salary12+salarycommission_pct "Total" FROM EMPLOYEES;
• BSELECTfirst_name,salary, salary12+NVL((salarycommission_pct), 0) "Total" FROMEMPLOYEES;
• CSELECTfirst_name, salary, salary*12 + NVL(salary, O)*commission_pct "Total" FROM EMPLOYEES;
• DSELECTfirst_name, salary, salary12+(salaryNVL2(commission_pct, salary,salary+commission_pct))"Total"

• A
  3% (1)
• B
  74% (23)
• C
  6% (2)
• D
  16% (5)

No community discussion yet for this question.