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

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

No change is required to achieve the desired results.

B

SELECT ename, sal, 12*(sal+100) FROM emp;

C

SELECT ename, sal, (12*sal)+100 FROM emp;

D

SELECT ename, sal+100,*12 FROM emp;

相似考题

1.以下语句不正确的是( )A.select * from emp;B.select ename,hiredate,sal from emp;C.select * from emp order deptno;D.select * from where deptno=1 and sal

2.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 abovesyntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）A. No change is required to achieve the desired results.B. SELECT ename, sal, 12* (sal+100) FROM emp;C. SELECT ename, sal, (12* sal)+100 FROM emp;D. SELECT ename, sal +100,*12 FROM emp;

3.Evaluate the SQL statement:SELECT ROUND(45.953, －1), TRUNC(45.936, 2)FROM dual;Which values are displayed? ()A. 46 and 45B. 46 and 45.93C. 50 and 45.93D. 50 and 45.9E. 45 and 45.93F. 45.95 and 45.93

4.Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

更多“Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 F”相关问题

  • 第1题：

    The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

    A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

    B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

    C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

    D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


    参考答案：C

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


    参考答案：A

  • 第3题：

    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

    • A、SELECT ename, salary*12 'Annual Salary' FROM employees;
    • B、SELECT ename, salary*12 "Annual Salary" FROM employees;
    • C、SELECT ename, salary*12 AS Annual Salary FROM employees;
    • D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

    正确答案:B

  • 第4题：

    下列（）命令在记录上设置了一个或多个排他锁。

    • A、ALTERTABLEEMPADDCOLUMNBIRTHDAY（DATE）；
    • B、UPDATEEMPSETSAL=SAL*1.5+100；
    • C、UPDATEEMPSETSAL=SAL*1.1WHEREEMPNO=OOO01；
    • D、SELECT*FROMEMP；
    • E、DROPTABLEEMP；
    • F、CREATEINDEXENAME_IDXONEMP（ENAME）；

    正确答案:B,C

  • 第5题：

    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

    正确答案:A

  • 第6题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

    • A、LOCK TABLE emp IN SHARE MODE；
    • B、LOCK TABLE emp IN EXCLUSIVE MODE；
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

    正确答案:A,B,E

  • 第7题：

    Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE 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

    正确答案:D

  • 第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"?（）

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

    正确答案:B

  • 第9题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第10题：

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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    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


    参考答案：D

  • 第14题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

    A.

    B.

    C.

    D.


    参考答案：C

  • 第15题：

    The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）

    • A、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
    • B、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
    • C、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';
    • D、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n';

    正确答案:A

  • 第16题：

    Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE 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

    正确答案:E

  • 第17题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）

    • A、LOCK TABLE emp IN SHARE MODE；
    • B、LOCK TABLE emp IN EXCLUSIVE MODE；
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

    正确答案:A,B,E

  • 第18题：

    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

    • A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
    • B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
    • C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
    • D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

    正确答案:C

  • 第19题：

    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

    正确答案:C

  • 第20题：

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

    No change is required to achieve the desired results.

    B

    SELECT ename, sal, 12* (sal+100) FROM emp;

    C

    SELECT ename, sal, (12* sal)+100 FROM emp;

    D

    SELECT ename, sal +100,*12 FROM emp;


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

  • 第21题：

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

    No change is required to achieve the desired results.

    B

    SELECT ename, sal, 12*(sal+100) FROM emp;

    C

    SELECT ename, sal, (12*sal)+100 FROM emp;

    D

    SELECT ename, sal+100,*12 FROM emp;


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

  • 第22题：

    单选题
    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
    A

    SELECT ename, salary*12 ‘Annual Salary’   FROM employees;

    B

    SELECT ename, salary*12 “Annual Salary”   FROM employees;

    C

    SELECT ename, salary*12 AS Annual Salary   FROM employees;

    D

    SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)   FROM employees


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

  • 第23题：

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

  • 第24题：

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）
    A

    LOCK TABLE emp IN SHARE MODE；

    B

    LOCK TABLE emp IN EXCLUSIVE MODE；

    C

    UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？

    D

    INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；

    E

    SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno


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

相关内容