Oracle Exam 1Z0-071 Topic 6 Question 35 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 35
Topic #: 6

Examine the data in the ENPLOYEES table:

Which statement will compute the total annual compensation tor each employee

ASECECT last_namo, (menthy_salary + monthly_commission_pct) * 12 AS annual_comp
FROM employees;

BSELCECT last_namo, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp
FROM employees

CSELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * NVL
(monthly_commission_pct, 0)) AS annual_comp FROM employees

DSELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * monthly_commission_pct)
AS annual_comp FROM employees

Show Suggested Answer

Suggested Answer: C

by Margart at May 07, 2022, 05:27 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!