46 and 45
46 and 45.93
50 and 45.93
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
哪些是正确的 like 运算表达式?A.select * from net_46 where s_name like ’晓’B.select * from net_46 where s_name like ’&晓&’C.select * from net_46 where s_name like ’$晓$’D.select * from net_46 where s_name like ’%晓%’
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(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed? ()A. 0B. 1C. 0.00D. An error statement
显示本月月末的日期()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‘ACCP’ FROM DUAL 的执行结果是()。A、ACCPB、XC、编译错D、提示未选中行