题目
第1题
对于学生信息表:student(sno,sname,sex,age,dept),把所有的学生的年龄加2的操作是【 】。
第2题
对于学生信息表: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
第3题
对于学生信息表: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
第4题
对于学生信息表: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
第5题
对于学生信息表: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
第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.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'刘&'
第8题
对于学生信息表: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='张明'
第9题
对于学生信息表: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='张明'
第10题
对于学生信息表:student(sno,shame,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='张明'
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!