面试公司：智慧电子（广州）
广东智慧电子公司地址：广州天河区天河软件园建工路8号海旺大厦7层学生表Student
字段名类型字段说明备注
StunoVarchar学号主键
StunameVarchar姓名
StusexVarchar性别
StuaddrVarchar地址
StudateDate出生日期
StuageInt年龄
课程表Course
字段名类型字段说明备注
CourseidVarchar课程编号主键
CoursenameVarchar课程名称
成绩表Score
字段名类型字段说明备注
StunoVarchar学号
CourseidVarchar课程编号
ScoreFloat成绩
数据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(courseidchar(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,scorefrom student inner join score on student.stuno=score.stunoinner join course on course.courseid=score.courseid and stuname='zhangsan'4.计算课程名为计算机应用的平均成绩，显示信息：课程编号，课程名，平均成绩select course.courseid,coursename,avg(score)from course,scorewhere course.courseid=score.courseidgroup by course.courseidhaving coursename='计算机应用' 解答题1.结合一种缺陷管理工具说说缺陷的处理流程2bug记录包含了哪些内容，如何提交高质量的缺陷记录3.测试用例设计方法都有哪些？各种方法在什么情况下使用4.在文档不是很完善的情况下，如何进行有效的测试5 写一个程序，随机输入10个同学成绩，降序排序后输出，有限使用java
页:
[1]