搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

Evaluate this SQL statement:<br /> SELECT e.emp_name, d.dept_name<br /> FROM employees e<br /> JOIN departments d<br /> USING (department_id)<br /> WHERE d.department_id NOT IN (10,40)<br /> ORSER BY dept_name;<br /> The statement fails when executed. Which change fixes the error?（）

A、remove the ORDER BY clause

B、remove the table alias prefix from the WHERE clause

C、remove the table alias from the SELECT clause

D、prefix the column in the USING clause with the table alias

E、prefix the column in the ORDER BY clause with the table alias

F、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

查看正确答案
更多“ Evaluate this SQL statement:<br /> SELECT e.emp_name, d.dept_name<br /> FROM employees e<br /> JOIN departments d<br /> USING (department_id)<br /> WHERE d.department_id NOT IN (10,40)<br /> ORSER BY dept_name;<br /> The statement fails when executed. Which change fixes the error?（）”相关的问题
第1题
[] 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? （） 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、A. The value displayed in the CALC_VALUE column will be lower.&nbsp;&nbsp;B、B. The value displayed in the CALC_VALUE column will be higher.&nbsp;&nbsp;C、C. There will be no difference in the value displayed in the CALC_VALUE column.&nbsp;&nbsp;D、D. An error will be reported.&nbsp;&nbsp;

点击查看答案
第2题
[] Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（） Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（）

A、A. It executes successfully but partition pruning cannot happen for this partition key.&nbsp;&nbsp;B、B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.&nbsp;&nbsp;C、C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.&nbsp;&nbsp;D、D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.&nbsp;&nbsp;

点击查看答案
第3题
[单选题] Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?（）

A、Selection, projection, join&nbsp;&nbsp;B、Difference, projection, join&nbsp;&nbsp;C、Selection, intersection, join&nbsp;&nbsp;D、Intersection, projection, join&nbsp;&nbsp;E、Difference, projection, product&nbsp;&nbsp;

点击查看答案
第4题
[单选题] 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.&nbsp;&nbsp;B、The value displayed in the CALC_VALUE column will be higher.&nbsp;&nbsp;C、There will be no difference in the value displayed in the CALC_VALUE column.&nbsp;&nbsp;D、An error will be reported.&nbsp;&nbsp;

点击查看答案
第5题
[单选题] 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.&nbsp;&nbsp;B、The value displayed in the CALC_VALUE column will be higher.&nbsp;&nbsp;C、There will be no difference in the value displayed in the CALC_VALUE column.&nbsp;&nbsp;D、An error will be reported.&nbsp;&nbsp;

点击查看答案
第6题
[单选题] 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.&nbsp;&nbsp;B、The value displayed in the CALC_VALUE column will be higher.&nbsp;&nbsp;C、There will be no difference in the value displayed in the CALC_VALUE column.&nbsp;&nbsp;D、An error will be reported.&nbsp;&nbsp;

点击查看答案
第7题
[单选题] The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?（）

A、The results are not sorted.&nbsp;&nbsp;B、The results are sorted numerically.&nbsp;&nbsp;C、The results are sorted alphabetically.&nbsp;&nbsp;D、The results are sorted numerically and then alphabetically.&nbsp;&nbsp;

点击查看答案
第8题
[单选题] The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）

A、The results are not sorted.&nbsp;&nbsp;B、The results are sorted numerically.&nbsp;&nbsp;C、The results are sorted alphabetically.&nbsp;&nbsp;D、The results are sorted numerically and then alphabetically.&nbsp;&nbsp;

点击查看答案
第9题
[] Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（） Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）

A、A.No change is required to achieve the desired results.&nbsp;&nbsp;B、B.SELECT ename, sal, 12*(sal+100) FROM emp;&nbsp;&nbsp;C、C.SELECT ename, sal, (12*sal)+100 FROM emp;&nbsp;&nbsp;D、D.SELECT ename, sal+100,*12 FROM emp;&nbsp;&nbsp;

点击查看答案
第10题
[] Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（） Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）

A、A. 46 and 45&nbsp;&nbsp;B、B. 46 and 45.93&nbsp;&nbsp;C、C. 50 and 45.93&nbsp;&nbsp;D、D. 50 and 45.9&nbsp;&nbsp;E、E. 45 and 45.93&nbsp;&nbsp;F、F. 45.95 and 45.93&nbsp;&nbsp;

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服