Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 225

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 * NVL(monthly_commission_pct, 0)) AS annual_comp FROM employees;

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;

Correct Answer: A

To compute the total annual compensation for each employee, you need to multiply the monthly salary by 12 to get the annual salary. For employees with a commission percentage, you also need to calculate the annual commission, which is done by multiplying the monthly salary by the commission percentage, and then by 12. Since some employees have a NULL value for the commission percentage, using the NVL function ensures that NULL values are treated as 0. Option A correctly performs all these calculations by using NVL to handle NULL values for commission percentage.

Discussion

zouveOption: A

A tested

yaya32Option: A

A is correct