设student表中存放了学生的信息,要从student表中查出姓名(sname)的第二个字是“光”或"明"的学生的信息,正确的查询语句为: select * from student where()
第1题:
“从学生关系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′王_′
第2题:
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第3题:
(41)若要求查找姓名中第二个字为‘阳’字的学生的学号和姓名,下列 SQL 语句中,哪一个(些)是正
确的?
Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME = '__阳%'
Ⅱ. SELECT S#,SNAME FROM S WHERE SNAME LIKE '__阳%'
Ⅲ. SELECT S#,SNAME FROM S WHERE SNAME LIKE '%阳%'
A)只有Ⅰ
B)只有Ⅱ
C)只有Ⅲ
D)都正确
第4题:
对于学生信息表STUDENT(SNO, SNAME,SEX,AGE,DEPT)(STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT 5个属性组成,其中SNO为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是( )。A.SELECT SNAME,AGE FROM STUDENT WHERE AGE>20 AND AGE<23B. SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C.SELECT SNAME,AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23D.以上均不正确
第5题:
以下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′王_′
第6题:
对于学生信息表:student(sno,sname,sex,age,dept),如果把学生“小明”的姓名改为“小强”,则正确的语句是( )。
A)UPDATE SET sname=‘小明’WHERE sname=‘小强’
B)UPDATE student SET sname=‘小明’WHERE sname=‘小强’
C)UPDATE student SET sname=‘小强’
D)UPDATE student SET sname=‘小强’WHERE sname=‘小明’
第7题:
对于学生信息表:student(sno,sname,sex,age,dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是
A.UPDATE SET sname='张明'WHERE sname='张岩'
B.UPDATE student SET shame='张明'WHERE shame='张岩'
C.UPDATE student SET sname='张岩'
D.UPDATE student SET sname='张岩'WHERE sname='张明'
第8题:
若要求查找‘李’姓学生的学生号和姓名,正确的SQL语句是
A.SELECT S#,SNAME FROM S WHERE SNAME='李%.'
B.SELECT S#,SNAME FROM S WHERE SNAME LIKE '李%.'
C.SELECT S#,SNAME FROM S WHERE SNAME='%.李%.'
D.SELECT S#,SNAME FROM S WHERE SNAME LIKE '%.李%.'
第9题:
若要求查找姓名中第一个字为“李”的学生号和姓名。下面列出的SQL语句中,哪个(些)是正确的?
Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME=‘李%’
Ⅱ.SELECT S#,SNAME FROM S WIERE SNAME LIKE'李%'
Ⅲ.SELECT S#,SNAME FROM S WHERE SNAME LIKE'李_'
A.Ⅰ
B.Ⅱ
C.Ⅲ
D.全部
第10题:
若要求查找姓名中第一个字为’王’的学生号和姓名。下面列出的SQL语句中,哪个(些)是正确的?______。 Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME='王%' Ⅱ.SELECT S#,SNAME FROM S WHERE SNAME LIKE'王%' Ⅲ.SELECT S#,SNAME FROM S WHERE SNAME LIKE'王_'
A.Ⅰ
B.Ⅱ
C.Ⅲ
D.全部