广东智慧电子 公司地址:广州天河区天河软件园建工路8号海旺大厦7层 数据 create table student( stuno int(10) primary KEY, stuname CHAR(10), stusex char(10), stuaddr char(10), studata date, stuage int ) insert into student values(1,'zhangsan','男','江苏','1991-04-20',18) insert into student values(2,'lisi','女','北京','1980-04-20',40); insert into student values(3,'wangwu','男','广东','1981-04-20',30); insert into student values(4,'zhaoliu','女','湖南','1982-04-20',28); create table course( courseid char(10) primary key, coursename char(10) ) insert into course values('NO01','语文') insert into course values('NO02','计算机应用'); insert into course values('NO03','数学'); insert into course values('NO04','英语'); create table score( stuno int(10), courseid char(10), score int(10) ) insert into score values(1,'NO01',89); insert into score values(1,'NO02',67); insert into score values(1,'NO03',90); insert into score values(1,'NO04',60); insert into score values(2,'NO01',100); insert into score values(2,'NO02',90); insert into score values(2,'NO03',93); insert into score values(2,'NO04',63); insert into score values(3,'NO01',78); insert into score values(3,'NO02',67); insert into score values(3,'NO03',90); insert into score values(3,'NO04',65); insert into score values(4,'NO01',89); insert into score values(4,'NO02',69); insert into score values(4,'NO03',95); insert into score values(4,'NO04',70); 答案 1查询地址包含北京的同学 select * from student where stuaddr like '%北京%' 2.更新出生日在1980到1981年的同学,年龄增加1岁 update student set stuage=stuage+1 where studata between '1980-01-01' and '1981-12-30' 3. 查询姓名为zhangsan的成绩。显示信息:学号,姓名,课程,成绩 select student.stuno,stuname,coursename,score from student inner join score on student.stuno=score.stuno inner join course on course.courseid=score.courseid and stuname='zhangsan' 4.计算课程名为计算机应用的平均成绩,显示信息:课程编号,课程名,平均成绩 select course.courseid,coursename,avg(score) from course,score where course.courseid=score.courseid group by course.courseid having coursename='计算机应用' 解答题 1.结合一种缺陷管理工具说说缺陷的处理流程 2bug记录包含了哪些内容,如何提交高质量的缺陷记录 3.测试用例设计方法都有哪些?各种方法在什么情况下使用 4.在文档不是很完善的情况下,如何进行有效的测试 5 写一个程序,随机输入10个同学成绩,降序排序后输出,有限使用java
|