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

Evaluate this SQL statement:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080116554090144.jpg?sign=67e5091108546699e5fa156c5dfc1ca1&t=62d173fe" /><br /> 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

查看正确答案
更多“ Evaluate this SQL statement:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080116554090144.jpg?sign=67e5091108546699e5fa156c5dfc1ca1&t=62d173fe" /><br /> In the statement, which capabilities of a SELECT statement are performed?（）”相关的问题
第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: 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;

点击查看答案
第4题
[单选题] 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;

点击查看答案
第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题
[单选题] 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;

点击查看答案
第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题
[] 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;

点击查看答案
第9题
[] 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

请使用微信扫码支付

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