A.SELECT S#, SNAME FROM SC GROUP BY S#
B.SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)>3
C.SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)>3
D.SELECT S# FROM SC WHERE COUNT(*)>3 GROUP BY S#
A.SELECT 学号, AVG(成绩) FROM SC WHERE AVG(成绩)>80
B.SELECT 学号, AVG(成绩) FROM SC WHERE AVG(成绩)>80 GROUP BY 学号
C.SELECT 学号, AVG(成绩) FROM SC GROUP BY 学号 HAVING AVG(成绩)>80
D.SELECT 学号, 成绩 FROM SC GROUP BY 学号 HAVING AVG(成绩)>80
开始考试点击查看答案A.S和SC
B.SC和C
C.S和C
D.S、SC和C
开始考试点击查看答案A.IN
B.LIKE
C.EXISTS
D.比较运算
开始考试点击查看答案A.FROM子句
B.WHERE子句
C.GROUP BY子句
D.ORDER BY 子句
开始考试点击查看答案A.CREATE
B.UPDATE
C.INSERT
D.ALTER
开始考试点击查看答案A.更新视图
B.查询视图
C.在视图上定义新的基本表
D.在视图上定义新视图
开始考试点击查看答案A.DBMS自动保证
B.用户定义的完整性约束来保证
C.定义外键来保证
D.定义主键来保证
开始考试点击查看答案A.NOT NULL
B.PRIMARY KEY
C.UNIQUE
D.FOREIGN KEY
开始考试点击查看答案A.INSERT INTO STU VALUES(‘1031’,’张华’,男,23)
B.INSERT INTO STU VALUES (‘1031’,’ 张华’,NULL,NULL)
C.INSERT INTO STU VALUES(NULL,’ 张华’,’男’,23)
D.INSERT INTO STU VALUES (‘1031’,NULL, ’男’,23)
开始考试点击查看答案A.SELECT
B.UPDATE
C.INSERT
D.DELETE
开始考试点击查看答案长理培训客户端 资讯,试题,视频一手掌握
去 App Store 免费下载 iOS 客户端