数据库实用技术次(在线作业).docVIP

个人收集整理 仅供参考学习 个人收集整理 仅供参考学习 PAGE / NUMPAGES 个人收集整理 仅供参考学习 1.根据SQL标准,要修改表student中所有学生地年龄age,使之在原值基础上减一,下面哪个语句适用？ A update student set age = 1 B update student set age = age - 1 C update age = age -1 from student D update from student where age = age -1 正确答案:B 2.根据SQL标准,要查询表student中所有年龄age小于所有学生地平均年龄地记录,下面哪条语句适用？b5E2RGbCAP A select * from student where age avg(age) B select * from student having age avg(age) C select * from student a where a.age (select avg(b.age) from student b)p1EanqFDPw D select * from student a where (select avg(b.age) from student b ) = a.age DXDiTa9E3d 正确答案:C 3. 如果