听力原文:W: How did your interview go?Have you got the latest news?
M: No,I couldn't feel worse about it.The questions were very fair but I seemed to find no answers fol'all of them.
Q: How does the man feel about the interview?
(19)
A.Confident.
B.Worried.
C.Surprised.
D.Angry.
第1题
有如下SQL语句 SELECT 单位,avg(基本工资)as 平均基本工资 FROM zg; GROUP BY 单位 INTO DBF temp 执行该语句后temp表中第2条记录的“均价”字段的内容是()。
A.500
B.600
C.800
D.900
第2题
求每个终点的平均票价的SQL语句是
A.SELECT终点,avg(票价)FROM ticket GROUP BY票价
B.SELECT终点,avg(票价)FROM ticket ORDER BY票价
C.SELECT终点,avg(票价)FROM ticket ORDER BY终点
D.SELECT终点,avg(票价)FROM ticket GROUP BY终点
第3题
求每个交易所的平均单价的SQL语句是
A.SELECT交易所,avg(单价)FROM stock GROUP BY单价
B.SELECT 交易所,avg(单价) FROM stock ORDER BY单价
C.SELECT 交易所,avg(单价) FROM stock ORDER BY交易所
D.SELECT 交易所,avg(单价) FROM stock GROUP BY交易所
第4题
求每个终点的平均票价的SQL语句是
A.SELECT终点,avg (票价) FROM ticket GROUP BY 票价
B.SELECT终点,avg (票价) FROM ticket ORDER BY 票价
C.SELECT终点,avg (票价) FROM ticket ORDER BY 终点
D.SELECT终点,avg (票价) FROM ticket GROUP BY 终点
第5题
求每个交易所的平均单价的SQL语句是______。
A.SELECT 交易所,avg(单价)FROM stock GROUP BY 单价
B.SELECT 交易所,avg(单价)FROM stock ORDER BY 单价
C.SELECT 交易所,avg(单价)FROM stock ORDER BY 交易所
D.SELECT 交易所,avg(单价)FROM stock GROUP BY 交易所
第6题
求每个终点的平均票价的SQL语句是
A.SELECT终点,avg(票价)FROM ticket GROUP BY票价
B.SELECT终点,avg(票价)FROM ticket ORDER BY票价
C.SELECT终点,avg(票价)FROM ticket ORDER BY终点
D.SELECT终点,avg(票价)FROM ticket GROUP BY终点
第7题
求每个终点的平均票价的SQL语句是:
A.SELECT终点,avg (票价) FROM ticket GROUP BY 票价
B.SELECT终点,avg (票价) FROM ticket ORDER BY 票价
C.SELECT终点,avg (票价) FROM ticket ORDER BY 终点
D.SELECT终点,avg (票价) FROM ticket GROUP BY 终点
第8题
若需统计zg表中车身厂的职工工资总和,下面语句正确的是()。
A.SELECT SUM(基本工资)FROM zg
B.SELECT SUM(基本工资)FROM zgWHERE 单位=“车身厂”
C.SELECT COUNT(基本工资)FROM zg
D.SELECT COUNT(基本工资)FROM zgWHERE单位=“车身厂”
第9题
列出工资表中基本工资在1200元~1800元之间的职工信息,应使用的SQL查询语句是______。
A.SELECT*FROM工资WHERE基本工资>=1200 OR基本工资<=1800
B.SELECT*FROM工资WHERE基本工资IN(1200,1800)
C.SELECT*FROM工资WHERE基本工资BETWEEN 1200 AND 1800
D.SELECT*FROM工资WHERE基本工资LIKE(1200,1800)
第10题
有如下SQL语句 CREATE VIEW zg-view AS SELECT姓名 AS 职工姓名,基本工资FROM zg执行该语句后产生的视图含有的字段名是()。
A.姓名、基本工资
B.职工姓名、基本工资
C.职工姓名、基本工资、单位
D.职工姓名、基本工资、单位
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!