题目
第1题
A.SELECT empno,ename FROM empWHERE empno=(SELECT empno FROM dept WHERE dname="研发部")
B.SELECT empno,ename FROM empWHERE deptno=(SELECT deptno FROM dept WHERE dname='研发部')
C.SELECT empno,ename FROM empWHERE deptno=(SELECT * FROM dept WHERE dname='研发部')
D.SELECT empno,ename FROM deptWHERE deptno=(SELECT deptno FROM emp WHERE dname="研发部")
第2题
A、Select Distinct Job From emp
B、Select Job From emp
C、Select *, Job From emp
D、Select Distinct * From emp
第3题
A.在补全代码处使用rs.getInt("empno");可以直接获取字段名为empno的值
B.在补全代码处使用rs.next;方法判断是否还有下一个值
C.在补全代码处使用rs.next;方法执行返回true,指针下移,可以使用rs.getXxx获取数据
D.在补全代码处使用rs.next;方法返回的是下一行数据
第4题
第5题
A、Select * From Emp Where EmpNO Not In(’791’,’792’,’793’)
B、Select * From Emp Where EmpNO =(’791’,’792’,’793’)
C、Select * From Emp Where EmpNO ==(’791’,’792’,’793’)
D、Select * From Emp Where EmpNO In(’791’,’792’,’793’)
第7题
A、Select Name,Job,(Sal*12 +100+200) As Income From Emp
B、Select Name,Job,(Sal+100+200)*12 As Income From Emp
C、Select Name,Job,(Sal+100+200)/12 As Income From Emp
D、Select Name,Job,(Sal+300)/12 As Income From Emp
第8题
A、Select * From EMPWhere EName Like ’_A%’
B、Select * From EMPWhere EName Like ’A%’
C、Select * From EMPWhere EName Like ’A%’
D、Select * From EMPWhere EName = ’_A%’
第9题
A.select count(all) from emp;
B.select count(emp_id) from emp;
C.select count(*) from emp;
D.select count(1) from emp;
第10题
A.select count(*)fromemp
B.select count(empid)fromemp
C.select count(l)fromemp
D.select count(1)fromemp
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!