Evaluate this SQL statement: 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?（）<br>A:The value displayed in the CALC_VALUE column will be lower.<br>B:The value displayed in the CALC_VALUE column will be higher.<br>C:There will be no difference in the value displayed in the CALC_VALUE column.<br>D:An error will be reported.

Evaluate this SQL statement: 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.

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

收藏本站【zk.995w.com】，下次访问不迷路

本站试题总数:【10245188】个 (题库试题定时更新)