1.设有一个学生选课数据库,其包括学生表S、课程表C和学生选课表SC三个关系:
S(SNO, SNAME, SAGE, SSEX, SDEP);
C(CNO, CNAME);
SC(SNO, CNO, GRADE)。
其中SNO是学生号,SNAME是学生姓名,SAGE是年龄,SDEP是学生所在系,CNO是课程号,CNAME是课程名称。
检索所有比“刘晨”年龄大的学生姓名、年龄和性别。正确的SELECT语句是()。正确答案:A
A.
SELECT SNAME, SAGE, SSEX FROM S
WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = ‘刘晨’);
B.
SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';
C.
SELECT SNAME, SAGE, SSEX FROM S
WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");
D.
SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'王华'.SAGE;
2.检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。正确答案:D
A.
SELECT SNO FROM SC
WHERE CNO='C2' AND GRADE >= (
SELECT GRADE FORM SC WHERE CNO='C2'
);
B.
SELECT SNO FROM SC
WHERE CNO='C2' AND GRADE IN (
SELECT GRADE FORM SC WHERE CNO='C2'
);
C.
SELECT SNO FROM SC
WHERE CNO='C2' AND GRADE NOT IN (
SELECT GRADE FORM SC WHERE CNO='C2'
);
D.
SELECT SNO FROM SC
WHERE CNO='C2' AND GRADE >= ALL (
SELECT GRADE FORM SC WHERE CNO='C2'
);
3.检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的SELECT语句是()。正确答案:B
A.
SELECT SNO, SUM (GRADE) FROM SC GROUP BY SNO ORDER BY 2 DESC HAVING COUNT(*) >= 4;
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;
4.以下对触发器概念理解正确的是()。 正确答案:A
A.
触发器经常用于加强数据的完整性约束和业务规则等,其由事件来触发执行。
B.
触发器一旦被激活,则触发动作体在触发器激活后立即执行
C.
在一个数据库中,触发器的命名必须是唯一的
D.
触发器类似于存储过程,需要用户手工启动或程序调用
5.“查询与‘刘晨’在同一个系学习的学生”的SQL语句为()。
** 正确答案:A、B、D
A.
SELECT SNO, SNAME, SAGE, SSEX, SDEP FROM S
WHERE SDEP IN (SELECT SDEP
FROM S WHERE SNAME = '刘晨');
B.
SELECT * FROM S WHERE SDEP IN (SELECT SDEP
FROM S WHERE SNAME ='刘晨');
C.
SELECT SNO, SNAME, SAGE, SSEX, SDEP FROM S WHERE SNAME = '刘晨';
D.
SELECT S1.SNO, S1.SNAME, S1.SAGE, S1.SSEX, S1.SDEP FROM S S1, S S2
WHERE S1.SDEPT = S2.SDEPT AND S2.SNAME = '刘晨';
6.“查询计算机科学系年龄大于19岁的学生”的SQL语句为()。
正确答案:A、B
A.
**SELECT * FROM S WHERE SDEP = ‘CS’ EXCEPT SELECT * FROM S WHERE SAGE<=19;
B.
**SELECT * FROM S WHERE SDEP = 'CS' AND SAGE > 19;****
C.
SELECT * FROM S WHERE SDEP = 'CS' AND SAGE <= 19;
D.
SELECT * FROM S WHERE SDEP != 'CS' AND SAGE <= 19;
7.在SQL语言中,为了数据库的安全性,设置了对数据的存取进行控制的语句,对用户授权、收回所授权限的关键字为()。正确答案:A、B
A.
GRANT
B.
REVOKE
C.
CREATE
D.
DELETE
8.强制存取控制的安全级别高于自主存取控制。正确答案:A
A. 对
B. 错
9.数据库加密技术提高了安全性的同时,增加了查询处理的复杂性,效率降低。正确答案:A
A.对
B.错
10.在参照完整性检查中,对参照表进行增、删、改操作时,有可能破坏参照完整性,而对被参照表进行增、删、改操作时,则不会破坏参照完整性。正确答案:B
A.对
B.错