可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The EMPLOYEE tables has these columns


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?()

  • A SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
  • B SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
  • C SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
  • D SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES
参考答案
参考解析:
分类:1Z0-007题库