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

Oracle认证考试

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

Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation?()

  • A、The value displayed in the CALC_VALUE column will be lower.
  • B、The value displayed in the CALC_VALUE column will be higher.
  • C、There will be no difference in the value displayed in the CALC_VALUE column.
  • D、An error will be reported.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题