网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Select ‘accp’ from dual后运行结果是（）。
A
null
B
0
C
accp
D
编译出错
参考答案
参考解析
解析：
暂无解析
更多 “单选题Select ‘accp’ from dual后运行结果是（）。A nullB 0C accpD 编译出错” 相关考题
考题
语句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
考题
执行以下代码,输出结果的结果是?()publicclassTest{publicString[]ss=newString[5];publicstaticvoidmain(String[]args){System.out.println(ss[1]);}}
A.nullB.-1C.编译时出错D.运行时报错
考题
显示本月月末的日期()
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;
考题
执行以下代码，输出结果的结果是？ （） public class Test{ public String[] ss = new String[5]； public static void main（String[] args）{ System.out.println（ss[1]）； } } A、 nullB、 -1C、 编译时出错D、 运行时报错
考题
查询student表中的所有非空email信息，以下语句正确的是（）。A、Select email from student where email !=nullB、Select email from student where email not is nullC、Select email from student where email nullD、Select email from student where email is not null
考题
查询student表中的所有非空email信息，以下语句正确的是（）A、Select email from student where email!=nullB、Select email from student where emailnotisnullC、Select email from student where emailnullD、Select email from student where emailisnotnull
考题
显示本月月末的日期（）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 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;
考题
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;
考题
如何显示今天是星期几（周一到周日，分别用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;
考题
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;
考题
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 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;
考题
单选题语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。A
2011-05-28B
2011-05-31C
2011-04-30D
2011-05-07
考题
多选题Which three SELECT statements display 2000 in the format "$2,000.00"? （）ASELECT TO_CHAR(2000, '$#,###.##') FROM dual;BSELECT TO_CHAR(2000, '$0,000.00') FROM dual;CSELECT TO_CHAR(2000, '$9,999.00') FROM dual;DSELECT TO_CHAR(2000, '$9,999.99') FROM dual;ESELECT TO_CHAR(2000, '$2,000.00') FROM dual;FSELECT 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;
考题
单选题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;
考题
单选题执行以下代码，输出结果的结果是？ （） public class Test{ public String[] ss = new String[5]； public static void main（String[] args）{ System.out.println（ss[1]）； } }A
nullB
-1C
编译时出错D
运行时报错
热门标签
最新试卷