A、1
B、2
C、3
D、4
第1题
select 专业,count(*) as 人数
from 学生
group by 专业
order by 专业
A、学生
B、人数
C、order by
D、专业
第2题
第3题
第4题
A、GRANT SELECT FROM 帐户 TO Jean
B、GRANT SELECT FROM 帐户 ON Jean
C、GRANT SELECT ON Jean FROM 帐户
D、GRANT SELECT ON 帐户 TO Jean
第5题
第7题
A、SELECT * FROM product WHERE max(price)>'一次性纸杯'
B、SELECT * FROM product WHERE price>(SELECT max(*) FROM product WHEREpName= '一次性纸杯')
C、SELECT * FROM product WHERE EXISTS pName='一次性纸杯'
D、SELECT * FROM product WHERE price>(SELECT max(price) FROM productWHERE pName='一次性纸杯')
第8题
A、SELECT*FROM STUDENTl WHERE CJ>300 AND XB----‘男’
B、SELECT*FROM STUDENTl WHERE CJ>=300
C、SELECT*FROM STUDENTl WHERE CJ>=300 AND XB—‘男’
D、以上都不是
第9题
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="研发部")
第10题