试题详情
单项选择题 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
  • 关注下方微信公众号,在线模考后查看

热门试题