【ocp-12c】最新Oracle OCP-071考试题库（39题）

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 percentage commission earned for a year.

Only a few employees earn commission.

Which SQL statement would you execute to get the desired output?

A) SELECT first_name,salary,salary12 + NVL(salary,0)commission_pct "Total"

FROM EMPLOYEES;

B) SELECT first_name,salary12+(salaryNVL2(commission_pct,

salary,salary+commission_pct)) "Total"

FROM EMPLOYEES;

C) SELECT first_name,(salary + NVL(commission_pct,0)salary)12 "Total"

FROM EMPLOYEES;

D) SELECT first_name,salary12+salarycommission_pct "Total"

FROM EMPLOYEES;

Answer：A

(解析：题眼是“Only a few employees earn commission”，说明有人的佣金是 null，所以要用 nvl 函数)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!