在存储保护模式中,可分为: I.执行级(Executive),用E表示; Ⅱ.管理级(Supervisor),用S表示; Ⅲ.核心级(Kernel),用K表示; Ⅳ.用户级(User),用U表示。 其优先级从高到低的次序为______。
A. SKEU
B. SEUK
C. KSEU
D. KESU
查看答案
This is one of the foods that my doctor has forbidden me ().
A. eating
B. to eat
C. eat
D. to be eaten
在数据库设计器中,建立两个表之问的一对多联系是通过以下索引实现的_____。
A. “一方”表的主索引或候选索引,“多方”表的普通索引
B. “一方”表的主索引,“多方”表的普通索引或候选索引
C. “一方”表的普通索引,“多方”表的主索引或候选索引
D. “一方”表的普通索引,“多方”表的候选索引或普通索引
对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname, Teacher),其中S为学生表,SC为学生选课表,C为课程表,则对于语句:检索至少选修LIU老师所授课课程中一门课程的女生姓名,SQL语句错误的是______。
A. SELECT Sname FROM S,SC,C WHERE Sno=SSno AND SCno=Cno AND Teacher=‘LIU’AND Ssex=‘F’
B. SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’))
C. SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS (SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Teacher=‘LIU’))
D. SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Cno=SCno AND Teacher=‘LIU’))
关系SC(Sno,Cno,Grade)表示学号,课程号,成绩。现要查询平均分在90分以上的学生的学号和平均成绩,正确的语句是______。
A. SELECT Sno,AVG(Grad FROM SC WHERE AVG(Grad>=90 GROUP BY Sno
B. SELECT Sno,AVG(Grad FROM SC GROUP BY Sno HAVING AVG(Grad>=90
C. SELECT Sno,AVG(Grad FROM SC WHERE AVG(Grad>=90 ORDER BY Sno
D. SELECT Sno,AVG(Grad FROM SC GROUP BY Cno HAVING AVG(Grad>=90