第1题
对于学生信息表: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='张明' 第(38)~(40)题基于学生一课程数据库中的3个基本表: 学生信息表:s(sno,sname,sex,age,dept)主码为sno 课程信息表:c(cno,cname,teacher)主码为cno 学生选课信息表:sc(sno,cno,grade)主码为(sno,cno)
第2题
对于学生信息表: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='张明'
第3题
对于学生信息表: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='张明'
第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),能够得到年龄在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
第7题
对于学生信息表: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=‘张明’
第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, 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='张明'
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!