更多"对于学生信息表:student(sno,sname,sex,age,d"的相关试题:
[单项选择]对于学生信息表:student(sno, sname, sex, age, dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是
[单项选择]对于学生信息表:student(sno,Sname,sex,age,dept),如果把学生“小明”的姓名改为“小强”,则正确的语句是( )。
[单项选择]对于学生信息表: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=‘张明’
[单项选择]对于学生信息表: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 shame,sno FROM student WHERE age<=22
[单项选择]对于学生信息表:student(sno,sname,sex,age,dept),要查询所有刘姓学生的信息,正确的语句是
[单项选择]对于学生信息表: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