oracle数据库071试题,Oracle数据库之【ocp-12c】最新Oracle OCP-071考试题库（39题）

本文主要向大家介绍了Oracle数据库之【ocp-12c】最新Oracle OCP-071考试题库(39题)，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

39.choose the best answer

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, salary, salary12+(salaryNVL2(commission_pct,

salary,salary+commission_pct)) "Total"

FROM EMPLOYEES;

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

FROM EMPLOYEES;

D) SELECT first_name, salary, salary12+salarycommission_pct "Total"

FROM EMPLOYEES;

Answer：A

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

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！