将所有计算机系学生的年龄增加1岁的正确语句是：（ ）。
A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS';
B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS';
C: UPDATE Student SET Sage =Sage + 1 WHERE Sdept = 'CS';
D: UPDATE Student SET Sage += 1 WHERE Sdept = 'CS';
A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS';
B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS';
C: UPDATE Student SET Sage =Sage + 1 WHERE Sdept = 'CS';
D: UPDATE Student SET Sage += 1 WHERE Sdept = 'CS';
举一反三
- 使用STC数据库，将所有计算机系学生的年龄增加1岁的正确语句是（ ）。 A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS'; B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS'; C: UPDATE Student SET Sage = Sage + 1 WHERE Sdept = 'CS'; D: alter table student alter column sage=sage+1
- 对教材79页学生表的查询，若描述条件‘年龄大于计算机系某个学生的年龄’，可以表示为： A: WHERE sage>ANY(SELECT sage FROM student WHERE sdept='CS') B: WHERE sage>SOME(SELECT sage FROM student WHERE sdept='CS') C: WHERE sage>ALL(SELECT sage FROM student WHERE sdept='CS') D: WHERE sage>(SELECT MIN(sage) FROM student WHERE sdept='CS'))
- 使用教学（STC）数据库，与如下查询语句等价的是（ ）。 SELECT *FROM Student WHERE Sdept = 'CS' EXCEPT SELECT * FROM Student WHERE Sage <= 19; A: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19 B: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19 C: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19 D: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19
- 在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： A: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student ); WHERE Sdept = 'CS' B: SELECT Sname FROM Student WHERE Sage > AVG( SELECT Sage FROM Student WHERE Sdept = 'CS' ); C: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student WHERE Sdept = 'CS' ); D: SELECT Sname FROM Student WHERE AVG(Sage) > ( SELECT Sage FROM Student WHERE Sdept = 'CS' );
- 若将所有学生的年龄增加1岁，下列哪一个语句是正确的？（ ） A: UPDATE Student.Sage SET Sage = 1+Sage； B: UPDATE Student SET Sage = Sage + 1； C: UPDATE Student.Sage SET Sage = Sage + 1； D: UPDATE Student.* FROM Student SET Sage = Sage + 1；