题目内容（请给出正确答案）

[主观题]

Evaluate this SQL statement:SELECT e.employee_id, （.15* e.salary) + （.5 * e.commission_pct

Evaluate this SQL statement:SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUEFROM employees e, sales sWHERE 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.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“Evaluate this SQL statement:SE…”相关的问题

第1题

Evaluate the SQL statement:What will be displayed？（）

Evaluate the SQL statement:What will be displayed？

A. 0

B. 1

C. 0.00

D. An error statement

点击查看答案

第2题

点击查看答案

第3题

Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）

Examine the data of the EMPLOYEES table.EMPLOYEES

A. Examine the data of the EMPLOYEES table.EMPLOYEES

B. Examine the data of the EMPLOYEES table.EMPLOYEES

C. Examine the data of the EMPLOYEES table.EMPLOYEES

D. Examine the data of the EMPLOYEES table.EMPLOYEES

E. The SQL statement produces an error.

点击查看答案

第4题

Evaluate the SQL statement:SELECT ROUND（TRUNC（MOD（1600,10),-1),2)FROM dual;What will be displayed？（）

A. 0

B. 1

C. 0.00

D. An error statement

点击查看答案

第5题

Evaluate this SQL statement:e.employee_id, （.15* e.salary) + （.5 * e.commission_pct)+ （s.s

Evaluate this SQL statement:e.employee_id, (.15* e.salary) + (.5 * e.commission_pct)+ (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUEFROM employees e, sales sWHERE 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.

点击查看答案

第6题

A.Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

点击查看答案

第7题

Evaluate the SQL statement:SELECT ROUND（45.953, -1), TRUNC（45.936, 2)FROM dual;Which values are displayed？（）

A.46 and 45

B. 46 and 45.93

C. 50 and 45.93

D. 50 and 45.9

E. 45 and 45.93

F. 45.95 and 45.93

点击查看答案

第8题

Evaluate the SQL statement:SELECT LPAD （salary,10,*)FROM EMPWHERE EMP _ ID = 1001;If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed？（）

A. 17000.00

B. 17000*****

C. ****170.00

D. **17000.00

E. an error statement

点击查看答案

第9题

Evaluate this SQL statement:What will happen if you remove all the parentheses from the calculation？（）

Evaluate this SQL statement:What will happen if yo

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.

点击查看答案

第10题

Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT

_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed？（）

A.selection, projection, join

B.difference, projection, join

C.selection, intersection, join

D.intersection, projection, join

E.difference, projection, product

点击查看答案