首页计算机考试Oracle认证
(单选题)

The EMPLOYEE tables has these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?()

ASELECT last_name, (salary * 12) * commission_pct   FROM EMPLOYEES;

BSELECT last_name, (salary * 12) * IFNULL(commission_pct, 0)   FROM EMPLOYEES;

CSELECT last_name, (salary * 12) * NVL2(commission_pct, 0)   FROM EMPLOYEES;

DSELECT last_name, (salary * 12) * NVL(commission_pct, 0)   FROM EMPLOYEES;

正确答案

来源:www.examk.com

答案解析

快考试在线搜题