皮皮学，免费搜题
登录
搜题
【单选题】
在Word2010编辑状态下,插入图形并选择图形将自动出现“绘图工具”,插入图片并选 择图片将自动出现“图片工具”,关于它们的“格式”选项卡说法不对的是A.
在“绘图工具”下“格式”选项卡中有“形状样式”组
B.
在“绘图工具”下“格式”选项卡中有“文本”组
C.
在“图片工具”下“格式”选项卡中有“图片样式”组
D.
在“图片工具”下“格式”选项卡中没有“排列”组
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】检索选修四门以上课程的学生总成绩 (不统计不及格的课程),并要求按总成绩的降序排列出来。
A.
SELECT S#，SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞＝4 WHERE C#=“C2” AND GRADE＞＝ (SELECT GRADE FORM SC WHERE C#=“C2”)
B.
SELECT S# FORM SC WHERE C#=“C2” AND GRADE IN (SELECT GRADE FORM SC WHERE C#=“C2”)
C.
SELECT S# FORM SC WHERE C#=“C2” AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C#=“C2”)
D.
SELECT S# FORM SC WHERE C#=“C2” AND GRADE＞＝ALL (SELECT GRADE FORM SC WHERE C#=“C2”)
【单选题】检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的SELECT语句是()。
A.
SELECT SNO, SUM (GRADE) FROM SC GROUP BY SNO ORDER BY 2 DESC HAVING COUNT(*) >=
B.
SELECT SNO, SUM (GRADE) FROM SC GROUP BY SNO HAVING COUNT(*)>=4 ORDER BY 2 DESC;
C.
SELECT SNO, SUM (GRADE) FROM SC HAVING COUNT(*)>=4 GROUP BY SNO ORDER BY 2 DESC;
D.
SELECT SNO, SUM (GRADE) FROM SC ORDER BY 2 DESC GROUP BY SNO HAVING COUNT(*)>=4;
【简答题】受理站在接到旅客索赔要求时,应尽快做出赔偿决定,最迟在__天内将处理意见答复旅客。
【单选题】下列关于操作系统的描述不正确的是
A.
单用户系统只允许一个用户独占计算机全部资源
B.
多用户系统允许一个用户独占计算机全部资源
C.
单用户系统同时只能管理一个用户任务
D.
多用户系统能够同时管理多个用户任务
【单选题】检索选修四门以上课程的学生总成绩，并要求按总成绩的降序排列出来。正确的SELECT语句是（）。
A.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO ORDER BY SUM_GRADE DESC HAVING COUNT(*) >= 4;
B.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO HAVING COUNT(*)>=4 ORDER BY SUM_GRADE DESC;
C.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC HAVING COUNT(*)>=4 GROUP BY SNO ORDER BY SUM_GRADE DESC;
D.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC ORDER BY SUM_GRADE DESC GROUP BY SNO HAVING COUNT(*)>=4;
相关题目：