evaluate the following sql statement select e employeeid 15 salary 5..., Oracle SQL 9i, Databases

Test
- Model Test
Index

Question:Evaluate the following 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 all the parentheses are removed 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

/45

+ AnswerC

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 16357

Question:Evaluate the following 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 all the parentheses are removed 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