Examine the data in the EMPLOYEES table. Which statement will compute the total annual compensation for each employee?

Question

Exhibit

Options

• ASELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * monthly_commission_pct) AS
• BSELECT last_name, (monthly_salary + monthly_commission_pct) * 12 AS
• CSELECT last_name, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp
• DSELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * NVL

• A
  82% (55)
• B
  4% (3)
• C
  10% (7)
• D
  3% (2)

No community discussion yet for this question.