单选题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?（）

46 and 45

46 and 45.93

50 and 45.93

50 and 45.9

45 and 45.93

45.95 and 45.93

参考答案和解析

正确答案： C

解析：暂无解析

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

第1题

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）A、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C、SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;D、SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;E、SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

点击查看答案
第2题

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A、SELECT &1, "&2" FROM &3 WHERE last_name = '&8';B、SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';C、SELECT &1, &2 FROM &3 WHERE last_name = '&8';D、SELECT &1, '&2' FROM EMP WHERE last_name = '&8';

点击查看答案
第3题

Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A、0B、1C、0.00D、An error statement

点击查看答案
第4题

You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）A、SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

点击查看答案
第5题

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

点击查看答案
第6题

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.00B、17000*****C、****170.00D、**17000.00E、an error statement

点击查看答案
第7题

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 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 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容