单选题语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9
单选题
语句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
参考解析
解析：
暂无解析
相关考题：
语句select LAST_DAY(‘2011－05－01’)from dual;的结果是()。 A.2011-05-28B.2011-05-31C.2011-04-30D.2011-05-07
语句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
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
显示本月月末的日期() A.select last_date(sysdate) from dual;B.select finally_day(sysdate) from dual;C.select last_day(sysdate) from dual;D.select tail_day(sysdate) from dual;
以下哪条SELECT语句将返回一个数字值？（）A、SELECT SYSDATE + 600 / 24 FROM 雇员；B、SELECT ROUND（聘用日期， DAY） FROM 雇员；C、SELECT （SYSDATE - 聘用日期） / 7 FROM 雇员；D、SELECT SYSDATE - 7 FROM 雇员；
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;
变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）A、select round（v_time，’DAY’） from dualB、select round（v_time，’YEAR’） from dualC、select round（v_time，’MONTH’） from dualD、A select round（to_char（v_time，’yyyy’）） from dual
显示本月月末的日期（）A、select last_date(sysdate) from dual;B、select finally_day(sysdate) from dual;C、select last_day(sysdate) from dual;D、select tail_day(sysdate) from dual;
Which three SELECT statements displays 2000 in the format "$2,000.00"? （）A、SELECT TO CNAR(2000, '$#,###.##') FROM dual;B、SELECT TO CNAR(2000, '$0,000.00') FROM dual;C、SELECT TO CNAR(2000, '$9,999.00') FROM dual;D、SELECT TO CNAR(2000, '$9,999.99') FROM dual;E、SELECT TO CNAR(2000, '$2,000.00') FROM dual;F、SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;
Which three SELECT statements display 2000 in the format "$2,000.00"? （）A、SELECT TO_CHAR(2000, '$#,###.##') FROM dual;B、SELECT TO_CHAR(2000, '$0,000.00') FROM dual;C、SELECT TO_CHAR(2000, '$9,999.00') FROM dual;D、SELECT TO_CHAR(2000, '$9,999.99') FROM dual;E、SELECT TO_CHAR(2000, '$2,000.00') FROM dual;F、SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
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;
如何显示今天是星期几（周一到周日，分别用1~7表示）（）A、select to_char(sysdate,'D') from dual;B、select to_char(sysdate,'W') from dual;C、select to_char(sysdate,'D')-1 from dual;D、select to_char(sysdate-1,'D') from dual;E、select to_char(sysdate-1,'W') from dual;
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
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
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
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
语句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
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A16 B100 C160 D200 E150
单选题Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9E45 and 45.93F45.95 and 45.93
单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A0B1C0.00DAn error statement
单选题语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。A2011-05-28B2011-05-31C2011-04-30D2011-05-07
单选题Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）ASELECT SUBSTR( ‘Hello World’,1) FROM dual;BSELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;CSELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;DSELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;ESELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
单选题变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）Aselect round（v_time，’DAY’） from dualBselect round（v_time，’YEAR’） from dualCselect round（v_time，’MONTH’） from dualDA select round（to_char（v_time，’yyyy’）） from dual