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

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

相似考题

1.语句select ROUND(45.953,－1),TRUNC(45.936,2)from dual;的结果是()。A.46 and 45B.46 and 45.93C.50 and 45.93D.50 and 45.9

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

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

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

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(”相关问题

  • 第1题：

    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

  • 第2题：

    Evaluate the SQL statement:What will be displayed?()

    A. 0

    B. 1

    C. 0.00

    D. An error statement


    参考答案：A

  • 第3题：

    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

  • 第4题：

    Which SQL statement returns a numeric value?（）

    • A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
    • B、SELECT ROUND(hire_date) FROM EMP;
    • C、SELECT sysdate-hire_date FROM EMP;
    • D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;

    正确答案:C

  • 第5题：

    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）

    • A、The two statements produce identical results.
    • B、The second statement returns a syntax error.
    • C、There is no need to specify DESC because the results are sorted in descending order by default.
    • D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

    正确答案:A

  • 第6题：

    Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）

    • A、16 
    • B、100 
    • C、160 
    • D、200 
    • E、150

    正确答案:C

  • 第7题：

    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

  • 第8题：

    单选题
    语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。
    A

    46 and 45

    B

    46 and 45.93

    C

    50 and 45.93

    D

    50 and 45.9


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

  • 第9题：

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


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

  • 第10题：

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


    正确答案： 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 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

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

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：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题：

    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

  • 第18题：

    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

  • 第19题：

    语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。

    • A、46 and 45
    • B、46 and 45.93
    • C、50 and 45.93
    • D、50 and 45.9

    正确答案:C

  • 第20题：

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

  • 第21题：

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

  • 第22题：

    单选题
    Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）
    A

    16 

    B

    100 

    C

    160 

    D

    200 

    E

    150


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

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

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


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

相关内容