1、格式化输出表emp中的ename字段值,下面描述正确的是
A.Select lower(ename),upper(ename),initcap(ename) from emp; B.Select lower('ename'),upper(ename),initcap(ename) from emp; C.Select lower('ename'),upper('ename'),initcap('ename') from emp; D.Select lower(ename),upper(ename),initcap('ename') from emp;
2、字符串连接的操作,下面不正确的是
A.select ename||job from emp; B.select concat(ename,job) from emp; C.select ename+job from emp;
3、SQL:select length('hello world!') from dual;计算字符串的长度
A.11 B.12 C.13 D.14
4、根据下面取字段ENAME首字母和尾字母,需要使用到的字符串函数 <br/>ENAME 首字母 尾字母 <br/>---------- -------------------- ---- <br/>SMITH S H <br/>ALLEN A N <br/>WARD WD <br/>JONES J S <br/>MARTIN M N
A.select ename,substr(ename,5,1) "首字母",substr(ename,-1) "尾字母"from emp; B.select ename,substr(ename,2,1) "首字母",substr(ename,-1) "尾字母"from emp; C.select ename,substr(ename,1,1) "首字母",substr(ename,5,1) "尾字母"from emp; D.select ename,substr(ename,1,1) "首字母",substr(ename,-1) "尾字母"from emp;
5、select instr('hello ! Mike','!') from dual,结果为
A.7 B.6 C.8
6、写出填充函数,使得输出结果如下面的方式 <br/>ENAME ENAME <br/>-----SMITH SMITH----- <br/>------WARD WARD------ <br/>-----JONES JONES-----
A.select lpad(ename,10,'-') ename,rpad(ename,10,'-') ename from emp; B.select Rpad(ename,10,'-') ename,Lpad(ename,10,'-') ename from emp; C.select lpad(ename,10,'') ename,rpad(ename,10,'') ename from emp;
7、sql语句:SELECT REPLACE('JACK and JUE','J','BL') FROM DUAL的输出结果
A.BLACK and LUE B.JACK and BLUE C.BLACK and BLUE
8、数字操作函数SELECT ROUND(45.923,2), ROUND(45.923,0), ROUND(45.923,-1) FROM DUAL;
A.45.92 46 50 B.45.92 46 45 C.45.92 45 50
9、将当前日期输出成格式yyyy-mm-dd hh24miss字符串:
A.elect sysdate from dual; B.select to_char(sysdate,'yyyy-mm-dd hh24miss') from dual; C.select to_date(sysdate,'yyyy-mm-dd hh24miss') from dual;
10、下面语句正确的是
A.select to_number('abc') from dual; B.select to_number('123456') from dual; C.select to_date('20091131','yyyymmdd') from dual;
A.Select lower(ename),upper(ename),initcap(ename) from emp; B.Select lower('ename'),upper(ename),initcap(ename) from emp; C.Select lower('ename'),upper('ename'),initcap('ename') from emp; D.Select lower(ename),upper(ename),initcap('ename') from emp;
2、字符串连接的操作,下面不正确的是
A.select ename||job from emp; B.select concat(ename,job) from emp; C.select ename+job from emp;
3、SQL:select length('hello world!') from dual;计算字符串的长度
A.11 B.12 C.13 D.14
4、根据下面取字段ENAME首字母和尾字母,需要使用到的字符串函数 <br/>ENAME 首字母 尾字母 <br/>---------- -------------------- ---- <br/>SMITH S H <br/>ALLEN A N <br/>WARD WD <br/>JONES J S <br/>MARTIN M N
A.select ename,substr(ename,5,1) "首字母",substr(ename,-1) "尾字母"from emp; B.select ename,substr(ename,2,1) "首字母",substr(ename,-1) "尾字母"from emp; C.select ename,substr(ename,1,1) "首字母",substr(ename,5,1) "尾字母"from emp; D.select ename,substr(ename,1,1) "首字母",substr(ename,-1) "尾字母"from emp;
5、select instr('hello ! Mike','!') from dual,结果为
A.7 B.6 C.8
6、写出填充函数,使得输出结果如下面的方式 <br/>ENAME ENAME <br/>-----SMITH SMITH----- <br/>------WARD WARD------ <br/>-----JONES JONES-----
A.select lpad(ename,10,'-') ename,rpad(ename,10,'-') ename from emp; B.select Rpad(ename,10,'-') ename,Lpad(ename,10,'-') ename from emp; C.select lpad(ename,10,'') ename,rpad(ename,10,'') ename from emp;
7、sql语句:SELECT REPLACE('JACK and JUE','J','BL') FROM DUAL的输出结果
A.BLACK and LUE B.JACK and BLUE C.BLACK and BLUE
8、数字操作函数SELECT ROUND(45.923,2), ROUND(45.923,0), ROUND(45.923,-1) FROM DUAL;
A.45.92 46 50 B.45.92 46 45 C.45.92 45 50
9、将当前日期输出成格式yyyy-mm-dd hh24miss字符串:
A.elect sysdate from dual; B.select to_char(sysdate,'yyyy-mm-dd hh24miss') from dual; C.select to_date(sysdate,'yyyy-mm-dd hh24miss') from dual;
10、下面语句正确的是
A.select to_number('abc') from dual; B.select to_number('123456') from dual; C.select to_date('20091131','yyyymmdd') from dual;
2c
3b
4d
5a
7c
8a
9b
10c第六题没答案 不知道是题出错了 问要是一个左一个右 就是A
2.C
3.B
4.D
5.A
6.A
7.C
8.A
9.B
10.B
2 C
3 B
4 D
5 A
6 A
7 C
8 A
9 C
10 B
2c
3b
4d
5a
7c
8a
9b
10b--最后个的月份日期没有31天看快了
10 题 我汗!
select to_date('20091131','yyyymmdd') from dual; 我就说,这个格式应该是对的啊,咋没人选呢!
原来是这个!!!!