网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。
A
2011-05-28
B
2011-05-31
C
2011-04-30
D
2011-05-07
参考答案
参考解析
解析：
暂无解析
更多 “单选题语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。A 2011-05-28B 2011-05-31C 2011-04-30D 2011-05-07” 相关考题
考题
语句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
考题
显示本月月末的日期()
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;
考题
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）A、select seq.ROWNUM from dualB、select seq.ROWID from dualC、select seq.CURRVAL from dualD、select seq.NEXTVAL from dual
考题
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
考题
评估以下SELECT语句： SELECT SYSDATE+30 FROM dual； 该查询将返回哪个值？（）A、当前日期加30小时B、当前日期加30天C、当前日期加30个月D、不会返回任何值，因为SELECT语句会产生错误
考题
显示本月月末的日期（）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;
考题
查询出当前的数据库系统时间，精确到秒（）A、select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;B、select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;C、select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;D、select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
考题
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
考题
单选题语句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
考题
单选题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;
考题
单选题在ORACLE中，语句 select “test”||null from tableName, 结果是（）A
结果是testnullB
结果是空C
结果是NULLD
结果是test
考题
多选题Which three SELECT statements displays 2000 in the format "$2,000.00"? （）ASELECT TO CNAR(2000, '$#,###.##') FROM dual;BSELECT TO CNAR(2000, '$0,000.00') FROM dual;CSELECT TO CNAR(2000, '$9,999.00') FROM dual;DSELECT TO CNAR(2000, '$9,999.99') FROM dual;ESELECT TO CNAR(2000, '$2,000.00') FROM dual;FSELECT TO CNAR(2000, '$N,NNN.NN') 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 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;
热门标签
最新试卷