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? （）..

第1题

[] 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. B、B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key. C、C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key. D、D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

点击查看答案

第2题

[单选题] Evaluate this SQL statement: 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

点击查看答案

第3题

[单选题] 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. B、The results are sorted numerically. C、The results are sorted alphabetically. D、The results are sorted numerically and then alphabetically.

点击查看答案

第4题

[单选题] 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. B、The results are sorted numerically. C、The results are sorted alphabetically. D、The results are sorted numerically and then alphabetically.

点击查看答案

第5题

[] 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. B、B.SELECT ename, sal, 12*(sal+100) FROM emp; C、C.SELECT ename, sal, (12*sal)+100 FROM emp; D、D.SELECT ename, sal+100,*12 FROM emp;

点击查看答案

第6题

[] 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 B、B. 46 and 45.93 C、C. 50 and 45.93 D、D. 50 and 45.9 E、E. 45 and 45.93 F、F. 45.95 and 45.93

点击查看答案

第7题

[单选题] Evaluate the SQL statement: What will be displayed?（）

A、0 B、1 C、0.00 D、An error statement

点击查看答案

第8题