语句:select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是()。(选择两项)
第1题:
已知学生选课信息表:sc(sno,cno,grade)。查询“至少选修了一门课程,但没有学习成绩的学生学号和课程号”的SQL语句是
A.SELECT sno,cno FROM sc WHERE grade=NULL
B.SELECT sno,cno FROM sc WHERE grade IS‘’
C.SELECT sno,cno FROM sc WHERE grade IS NULL
D.SELECT sno,cno FROM sc WHERE grade=‘’
第2题:
设有关系模式SC(sno,eno,grade),查询既选修了c1又选修了c2课程的学生学号,正确的SQL命令是( )。
A.SELECT sno FROM sc WHERE cno="c1"AND cno="c2"
B.SELECT sno FROM sc WHERE cno="cl',AND SELECT sno FROM sc WHERE cno="c2"
C.SELECT sno FROM sc WHERE cno="cl" UNION SELECT sno FROM sc WHER:E cno="c2"
D.SELECT sno FROM sc WHERE cno="cl"AND sno IN(SELECT sno FROM sc WHERE cno="c2")
第3题:
假设供应商S和供应情况SPJ的关系模式分别为:S(Sno, Sname, Status, City)和SPJ(Sno, Pno, Jno, Qty)。SQL语句______不能正确地查询出“零件号Pno等于'P3'的供应商名Sname”。
A.SELECT DISTINCT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
B.SELECT DISTINCT Sname FROM S WHERERE 0< (SELECT COUNT (*) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
C.SELECT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
D.SELECT Sname FROM S, SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') GROUP BY Sname
第4题:
对于数据表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是______。
A.SELECT sno,sname FROM student WHERE gade=NULL
B.SELECT sno,sname FROM student WHERE grade IS NULL
C.SELECT sno,age FROM student WHERE grade IS NULL
D.SELECT mo,age FROM student WHERE grade=NULL
第5题:
对于学生信息表:student(sno,sname,sex,age,dept),要查询所有刘姓学生的信息,正确的语句是
A.SELECT * FROM student WHERE sname LIKE'刘 * '
B.SELECT * FROM student WHERE sname LIKE'刘 $'
C.SELECT * FROM student WHERE sname LIKE'刘%'
D.SELECT * FROM student WHERE sname LIKE'刘&'
第6题:
假设供应商S和供应情况SPJ的关系模式分别为S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句(25)不能正确地查询出“零件号Pno等于'P3'的供应商名Sname",而(26)能正确查询的关系代数表达式。
A.SELECT DISTINCT Sname FROM S WHERERE 0 <(SELECT COUNT( *)FROM SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3')
B.SELECT DISTINCT Sname FROM S WHERE EXISTS(SELECT * FROM SPJ WHERE S. Sno=SPJ. Sno AND SPJ. Pno= 'P3')
C.SELECT Sname FROM S WHERE EXISTS( SELECT * FROM SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3')
D.SELECT Sname FROM S, SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3' GROUP BY Sname
第7题:
假设供应商S和供应情况SPJ的关系模式分别为S(Sno,Snaale,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL。语句(19)不能正确地查询出“零件号Pno等于‘P3’的供应商名Snam”,而(20)能正确查询的关系代数表达式。
A.SELECT DISTINCTSname
B.SELECT DISTm CTSname FROMS FROMS WHERE EXISTS WHERE 0<(SELECT*(SELECTCOUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE S.Sno;SPJ.Sno AND SPJ.Pno;
C.SELECT Shame
D.SELECT Sname FROMS FROMS,SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT* ANDSPJ.Pno='P3')FROM SPJ GROUP BYSname WHERE S. Sno=SPJ. Sno
第8题:
假定学生关系是S(SNO,SNAME,SEX,AGE),其属性是学号,姓名,性别,年龄;课程关系是C(CNO,CNAME),属性是课程号,课程名;学生选课关系是SC(SNO,CNO,GRADE),属性是学号,课程号,成绩。要查找选修“COMPUTER”课程的“女”学生姓名,将涉及到关系有()、()、(),SQL语句为:SELECT SNAME FROM WHERE S.SNO=SC.SNO AND SC.CNO=C.CNO AND();查询所有课程都及格的学生学号,姓名,SQL语句为:SELECT SNO, SNAME FROM()WHERE() (SELECT * FROM SC WHERE S.SNO=SC.SNO AND ())。
第9题:
Sql语句:select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是()
第10题:
查询名字中第2个字为“阳”的学生的姓名和学号,正确的是()
第11题:
01053090A#Hm3?
01003090A01
01053090D09
0101A01
第12题:
01053090A
01003090A01
01053090D09
0101A01
第13题:
以下2题基于以下说明。设有三个关系:
学生关系S(SNO,SNAME,AGE,SEX) (分别代表学生的学号、姓名、年龄、性别)
学习关系SC(SNO,CNO,GRADE) (分别代表学生的学号、课程编号、成绩)
若在关系S中查找姓名中第一个字为′王′的学生的学号和姓名。下面列出的SQL语句中,正确的是
A.SELECT SNO,SNAME FROM S WHERE SNAME=′王%′
B.SELECT SNO,SNAME FROM S WHERE SNAME=′王_′
C.SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′
D.SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′
第14题:
已知有关系模式R(sno,sname,age),其中sno表示学生的学号,类型为Char(8),前4位表示入学年份。查询所有2003年入学的学生姓名(sname),SQL语句是 _______。
A.SELECT sname FROM R WHERE.sno='2003%'
B.SELECT sname FROM R WHERE sno LIKE '2003%'
C.SELECT sname FROM R WHERE sno='2003_'
D.SELECT sname FROM R WHERE sno LIKE '2003_'
第15题:
现在有两个关系模式:供应商S(Sno,Sname,Status,City)和供应情况SPJ(Sno,Pno,Jno, Qty)。对于查询“查询零件号Pno等于‘P3’的供应商名Sname”SQL语句(221)是错误的,而关系代数表达式(222)是正确的。
A.SELECTSname FROM S WHERE EXIST5(SELECT * FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
B.SELECT Sname FROM S,SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') CROUP BY Sname
C.SELECT DISTINCT Sname FROM S WHERE EXISTS(SELECT * FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
D.SELECT DISTINCT Sname FROM S WHERERE 0<(SELECTCOUNT(,) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pnn='P3')
第16题:
“找出北京供应商的所有信息”的SELECT语句是
A.SELECT*FROM S WHERE CITY='京'
B.SELECT SNO,SNAME FROM S WHERE CITY='北京'
C.SELECT*FROM S WHERE CITY=北京
D.SELECT SNO,SNAME FROM S WHERE CITY=北京
第17题:
对于学生信息表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是
A.SELECT sno,sname FROM student WHERE grade=NULL
B.SELECT sno,sname FROM student WHERE grade IS NULL
C.SELECT sno,age FROM student WHERE grade IS NULL
D.SELECT sno,age FROM student WHERE grade=NULL
第18题:
假设供应商S和供应情况SPJ的关系模式分别为:S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句(22)不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname",而(23).能正确查询的关系代数表达式。
A.SELECT DISTINCT Sname
B.SELECT DISTmCT Sname FROMS FROMS WHERE EXISTS WHERE 0<(SELECT *(SEIECT COUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE
C.SELECT Sname
D.SELECT Sname FROMS FROMS, SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT * AND SPJ.Pno= 'P3')FROM SPJ GROUP BYSname W
第19题:
学生一选课一课程数据库中的三个基本表: 学生信息表:STUDENT(sno,sname,sex,age,dept)主码为sno 课程信息表:CDLIRSB(cno,cname,teacher)主码为cno 学生选课信息表:SC(sno,cno,grade)主码为(sno,cno) “查询没有学习成绩的学生的学号和课程号”的SQL语句是()
第20题:
下列查询语句中,错误的是()。
第21题:
Sql语句:select*from students where SNO like‘010[^0]%[A,B,C]%’,可能会查询出的SNO是()。
第22题:
Select Sname,Sno from student where Sname like‘_阳%’;
Select Sname,Sno from student where Sname like‘阳%’;
Select Sname,Sno from student where Sname like‘_阳’;
Select Sname,Sno from student where Sname like‘阳_%’;
第23题:
01053090A
01003090A01
01053090D09
0101A01