单选题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 t

题目
单选题
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.

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.

相似考题

1.Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? （）A. remove the ORDER BY clauseB. remove the table alias prefix from the WHERE clauseC. remove the table alias from the SELECT clauseD. prefix the column in the USING clause with the table aliasE. prefix the column in the ORDER BY clause with the table aliasF. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

2.The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?（）A. All of the desired resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement

3.Evaluate this SQL statement: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.

4.Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product

更多“单选题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 t”相关问题

  • 第1题：

    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


    参考答案：A

  • 第2题：

    Click the Exhibit button to examine the data of the EMPLOYEES table.Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）

    A.SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;

    B.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;

    C.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000;

    D.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id", m.emp_name "Manager" FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary > 4000;

    E.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id" m.emp_name "Manager" FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary > 4000;


    参考答案：C

  • 第3题：

    ou have a computer that runs Windows 7. A printer is installed on the computer. You remove the Everyonegroup from the access control list (ACL) for the printer, and then you share the printer. You need to ensurethat members of the Sales group can modify all the print jobs that they submit. You must prevent Salesgroup members from modifying the print jobs of other users.  What should you do?（　）

    • A、From the printer s properties， assign the Print permission to the Sales group.
    • B、From the printer s properties， assign the Manage Documents permission to the Sales group.
    • C、From the local Group Policy， assign the Increase scheduling priority user right to the Sales group.
    • D、From the local Group Policy， assign the Take ownership of files or other objects user right to the Salesgroup.

    正确答案:A

  • 第4题：

    Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? （）

    • A、The statement produces an error at line 1.
    • B、The statement produces an error at line 3.
    • C、The statement produces an error at line 6.
    • D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
    • E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

    正确答案:E

  • 第5题：

    Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）

    • A、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary
    • B、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
    • C、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
    • D、You cannot find the information because there is no common column between the two tables.

    正确答案:A

  • 第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.
    • 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

  • 第7题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE 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


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE 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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（）
    A

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);

    B

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH READ ONLY;

    C

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH CHECK OPTION;

    D

    CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);

    E

    CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   NO UPDATE;


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE 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


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）
    A

    SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';

    B

    SELECT last_name FROM EMP WHERE last name ='*A%'

    C

    SELECT last_name FROM EMP WHERE last name ='_A%';

    D

    SELECT last_name FROM EMP WHERE last name LIKE '*A%'


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
    A

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary

    B

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

    C

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

    D

    You cannot find the information because there is no common column between the two tables.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager"FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary > 4000;What is its output?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第14题：

    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE 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

    正确答案:A

  • 第15题：

    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.
    • 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

  • 第16题：

    The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）

    • A、All of the desired results
    • B、Two of the desired results
    • C、One of the desired results
    • D、An error statement

    正确答案:C

  • 第17题：

    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE 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

    正确答案:A

  • 第18题：

    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE 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

    正确答案:A

  • 第19题：

    单选题
    Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?（）
    A

    The statement produces an error at line 1.

    B

    The statement produces an error at line 3.

    C

    The statement produces an error at line 6.

    D

    The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

    E

    The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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.

    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.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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.

    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
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）
    A

    All of the desired results

    B

    Two of the desired results

    C

    One of the desired results

    D

    An error statement


    正确答案： B
    解析： 暂无解析

相关内容