网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
语句：select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）。（选择两项）
- A、01053090A
- B、01003090A01
- C、01053090D09
- D、0101A01
参考答案
更多 “语句：select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）。（选择两项）A、01053090AB、01003090A01C、01053090D09D、0101A01” 相关考题
考题
关系SC(Sno，Cno，Grade)表示学号，课程号，成绩。现要查询平均分在90分以上的学生的学号和平均成绩，正确的语句是______。A．SELECT Sno，AVG(Grade) FROM SC WHERE AVG(Grade)＞=90 GROUP BY SnoB．SELECT Sno，AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)＞=90C．SELECT Sno，AVG(Grade) FROM SC WHERE AVG(Grade)＞=90 ORDER BY SnoD．SELECT Sno，AVG(Grade) FROM SC GROUP BY Cno HAVING AVG(Grade)＞=90
考题
在关系SC中，查询学习课程号为\'DB\'，且成绩在60至90之间的学生学号的正确的SQL命令是（ ）。A．SELECT SNO FROM SC WHERE CNO='DB'AND GRADE BETWEEN 60 AND 90B．SELECT SNO FROM SC WHERE CN0='DB' 0R GRADE BETWEEN 60 AND 90C．SELECT SNO FROM SC WHERE CNO='DB'AND GRADE=60 AND 90D．SELECT SNO FROM SC WHERE CNO='DB'AND GRADE=60 AND GRADE=90
考题
“从学生关系S中检索姓′王′的学生学号”的SQL语句是A．SELECT sno FROM sc WHERE sname=′王′B．SELECT sno FROM sc WHERE sname IS LIKE′王%′C．SELECT sno FROM sc WHERE sname LIKE′王%′D．SELECT sno FROM sc WHERE sname LIKE′王_′
考题
对于教学数据库的三个基本表：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 S.Sno=SC.Sno AND SC.Cno=C.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 SC.Sno=S.Sno AND EXISTS (SELECT*D．SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT*
考题
已知学生选课信息表：sc(sno，cno，grade)。查询“至少选修了一门课程，但没有学习成绩的学生学号和课程号”的SQL语句是A．SELECT sno，cno FROM sc WHERE grade=NULLB．SELECT sno，cno FROM sc WHERE grade IS‘’C．SELECT sno，cno FROM sc WHERE grade IS NULLD．SELECT sno，cno FROM sc WHERE grade=‘’
考题
以下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′王_′
考题
设有关系模式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")
考题
已知有关系模式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_'
考题
假设供应商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
考题
现在有两个关系模式：供应商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 SnameC．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')
考题
对于数据表：student(sno,sname,sex,age,grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是______。A．SELECT sno,sname FROM student WHERE gade=NULLB．SELECT sno,sname FROM student WHERE grade IS NULLC．SELECT sno,age FROM student WHERE grade IS NULLD．SELECT mo,age FROM student WHERE grade=NULL
考题
“找出北京供应商的所有信息”的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=北京
考题
对于学生信息表：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'刘'
考题
对于学生信息表：student(sno，sname，sex，age，grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是A．SELECT sno，sname FROM student WHERE grade=NULLB．SELECT sno，sname FROM student WHERE grade IS NULLC．SELECT sno，age FROM student WHERE grade IS NULLD．SELECT sno，age FROM student WHERE grade=NULL
考题
假设供应商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
考题
假设供应商S和供应情况SPJ的关系模式分别为：S(Sno，Sname，Status，City)和SPJ(Sno，Pno，Jno，Qty)。SQL语句(22)不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname"，而(23)．能正确查询的关系代数表达式。A．SELECT DISTINCT SnameB．SELECT DISTmCT Sname FROMS FROMS WHERE EXISTS WHERE 0＜(SELECT *(SEIECT COUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHEREC．SELECT SnameD．SELECT Sname FROMS FROMS, SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT * AND SPJ.Pno= 'P3')FROM SPJ GROUP BYSname W
考题
假设供应商S和供应情况SPJ的关系模式分别为S(Sno，Snaale，Status，City)和SPJ(Sno，Pno，Jno，Qty)。SQL。语句(19)不能正确地查询出“零件号Pno等于‘P3’的供应商名Snam”，而(20)能正确查询的关系代数表达式。A．SELECT DISTINCTSnameB．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 ShameD．SELECT Sname FROMS FROMS，SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT* ANDSPJ．Pno='P3')FROM SPJ GROUP BYSname WHERE S. Sno=SPJ. Sno
考题
学生一选课一课程数据库中的三个基本表： 学生信息表：STUDENT（sno，sname，sex，age，dept）主码为sno 课程信息表：CDLIRSB（cno，cname，teacher）主码为cno 学生选课信息表：SC（sno，cno，grade）主码为（sno，cno） “查询没有学习成绩的学生的学号和课程号”的SQL语句是（）A、SELECT snc，cno FROM SC WHERE grade=NULLB、SELECT sno，cno FROM SC WHERE gradeIS’’C、SELECT sno.cno FROM SC WHERE gradeISNULLD、SELECT sno.cno FROM SC WHERE grade=’ ’
考题
假定学生关系是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 （）)。
考题
下列查询语句中，错误的是（）。A、SELECT Sno， COUNT（*） FROM SC GROUP BY SnoB、SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*） 3C、SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*） 3D、SELECT Sno FROM SC GROUP BY Sno
考题
Sql语句：select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）A、01053090A#Hm3？B、01003090A01C、01053090D09D、0101A01
考题
Sql语句：select*from students where SNO like‘010[^0]%[A，B，C]%’，可能会查询出的SNO是（）。A、01053090AB、01003090A01C、01053090D09D、0101A01
考题
查询名字中第2个字为“阳”的学生的姓名和学号，正确的是（）A、Select Sname，Sno from student where Sname like‘_阳%’；B、Select Sname，Sno from student where Sname like‘阳%’；C、Select Sname，Sno from student where Sname like‘_阳’；D、Select Sname，Sno from student where Sname like‘阳_%’；
考题
单选题查询名字中第2个字为“阳”的学生的姓名和学号，正确的是（）A
Select Sname，Sno from student where Sname like‘_阳%’；B
Select Sname，Sno from student where Sname like‘阳%’；C
Select Sname，Sno from student where Sname like‘_阳’；D
Select Sname，Sno from student where Sname like‘阳_%’；
考题
多选题Sql语句：select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）A01053090A#Hm3？B01003090A01C01053090D09D0101A01
考题
多选题Sql语句：select*from students where SNO like‘010[^0]%[A，B，C]%’，可能会查询出的SNO是（）。A01053090AB01003090A01C01053090D09D0101A01
考题
多选题语句：select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）。（选择两项）A01053090AB01003090A01C01053090D09D0101A01
热门标签
最新试卷
