Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 52 of 57

Marks: +1, -0

Examine the data in the EMPLOYEES table.

Which statement will compute the total annual compensation for each employee?

SELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * monthly_commission_pct) AS annual_comp FROM employees;
SELECT last_name, (monthly_salary + monthly_commission_pct) * 12 AS annual_comp FROM employees;
SELECT last_name, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp FROM employees;
SELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * NVL (monthly_commission_pct, 0)) AS annual_comp FROM employees;

Go to Question:

Prev Question

Next Question