多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?()

  • A、SELECT last_name, 12*salary* commission_pct FROM emp;
  • B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
  • C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
  • D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题