1、计算emp表中员工的总薪水,最低薪水,最高薪水,平均薪水,下面的语句正确的是
A.select sum(sal),min(sal),max(sal),avg(sal) from emp; B.select count(sal),min(sal),max(sal),avg(sal) from emp;
2、计算员工总数,下面的语句正确的是
A.select count(*) from dual; B.select sum(*) from dual;
3、各部门的平均工资,下面的语句正确的是
A.select avg(sal) from emp; B.select avg(sal) from emp group by depno;
4、下面SQL 语法是否正确 <br/>select sum(decode(to_char(hiredate,'yyyy'),'1980',1,0)) "1980", <br/>sum(decode(to_char(hiredate,'yyyy'),'1981',1,0)) "1981", <br/>sum(decode(to_char(hiredate,'yyyy'),'1982',1,0)) "1982", <br/>sum(decode(to_char(hiredate,'yyyy'),'1987',1,0)) "1987", <br/>count(ename) "总人数" from emp;
A.正确 B.错误
5、emp表中有11行数据,demp表中有4行数据,SQL: <br/>select ename,dname from emp,dept; <br/>select ename,dname from emp cross join dept; 最终有多少条记录
A.4 B.0 C.44
6、语句select instr('oracle traning','ra',1,2) instring from dual;的运行结果
A.9 B.2 C.10 D.3
7、取出一个子字符串01234567,哪个sql是正确的
A.select substr('13012345678',3,8) from dual; B.select instr('13012345678',3,8) from dual; C.select substr('13012345678',1,8) from dual;
8、emp表中有20个员工信息,下面子查询写法不正确的是
A.Select ename from emp where sal=(Select max(sal) from emp); B.Select ename from emp where sal=(Select sal from emp); C.Select ename from emp where sal > (Select mis(sal) from emp);
9、select nvl(null,'1') from dual; 结果是
A.1 B.null
10、查询emp表中ename中为空的记录,查询正确的是
A.select * from emp where ename = null; B.select * from emp where ename is null;
A.select sum(sal),min(sal),max(sal),avg(sal) from emp; B.select count(sal),min(sal),max(sal),avg(sal) from emp;
2、计算员工总数,下面的语句正确的是
A.select count(*) from dual; B.select sum(*) from dual;
3、各部门的平均工资,下面的语句正确的是
A.select avg(sal) from emp; B.select avg(sal) from emp group by depno;
4、下面SQL 语法是否正确 <br/>select sum(decode(to_char(hiredate,'yyyy'),'1980',1,0)) "1980", <br/>sum(decode(to_char(hiredate,'yyyy'),'1981',1,0)) "1981", <br/>sum(decode(to_char(hiredate,'yyyy'),'1982',1,0)) "1982", <br/>sum(decode(to_char(hiredate,'yyyy'),'1987',1,0)) "1987", <br/>count(ename) "总人数" from emp;
A.正确 B.错误
5、emp表中有11行数据,demp表中有4行数据,SQL: <br/>select ename,dname from emp,dept; <br/>select ename,dname from emp cross join dept; 最终有多少条记录
A.4 B.0 C.44
6、语句select instr('oracle traning','ra',1,2) instring from dual;的运行结果
A.9 B.2 C.10 D.3
7、取出一个子字符串01234567,哪个sql是正确的
A.select substr('13012345678',3,8) from dual; B.select instr('13012345678',3,8) from dual; C.select substr('13012345678',1,8) from dual;
8、emp表中有20个员工信息,下面子查询写法不正确的是
A.Select ename from emp where sal=(Select max(sal) from emp); B.Select ename from emp where sal=(Select sal from emp); C.Select ename from emp where sal > (Select mis(sal) from emp);
9、select nvl(null,'1') from dual; 结果是
A.1 B.null
10、查询emp表中ename中为空的记录,查询正确的是
A.select * from emp where ename = null; B.select * from emp where ename is null;
2a
3b
4a
5c
6a
7a
8b
9a
10b
A A B A B
太简单了点..
A A B A B
这个比大学 数据库课程考试题目 都还要简单一些啊!呵呵!
2、计算员工总数,下面的语句正确的是
A.select count(*) from dual; B.select sum(*) from dual; A和B都错误,dual表不是员工表sum,avg不能不指定列,嘿嘿