测试面试题 上海-悠悠 著
测试面试题
作者:上海-悠悠
关注微信公众号:yoyoketang
个人博客地址:http://www.cnblogs.com/yoyoketang/
QQ 交流群:779429633
联系本人 QQ:283340479
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
目录
一、SQL 篇 ....................................................................................................................................... 6
SQL 学生表-1 ............................................................................................................................ 6
前言 ................................................................................................................................... 6
万年不变学生表 ............................................................................................................... 6
排序 order by .................................................................................................................... 7
统计总成绩 sum ............................................................................................................... 8
统计总成绩 ....................................................................................................................... 9
统计单科最好成绩 ........................................................................................................... 9
总结 group by 相关用法 ............................................................................................... 10
各门课程成绩最好的 2 位学生 ..................................................................................... 11
SQL 学生表-2 .......................................................................................................................... 11
前言 ................................................................................................................................. 11
万年不变学生表 ............................................................................................................. 12
计算学生平均分数 ......................................................................................................... 12
统计各科目成绩 ............................................................................................................. 13
每门课程平均成绩 ......................................................................................................... 15
成绩排名 ......................................................................................................................... 15
同结果名次相同 ............................................................................................................. 17
排名相同的占个名次 ..................................................................................................... 18
SQL 查询-3 .............................................................................................................................. 19
前言 ................................................................................................................................. 19
万年不变学生表 ............................................................................................................. 19
查询前 3 名 ..................................................................................................................... 20
查询第 2-3 名记录 ......................................................................................................... 21
查询第 3 到后面所有的 ................................................................................................. 22
英语课程少于 80 分的人 ............................................................................................... 23
统计每门课程不及格、一般、优秀 ............................................................................. 23
查找每科成绩前 2 名 ..................................................................................................... 24
SQL 经典面试题-4 .................................................................................................................. 26
前言 ................................................................................................................................. 26
having 和 not in............................................................................................................... 26
解决办法一: having .................................................................................................... 26
解决办法二:not in ....................................................................................................... 27
删除 ................................................................................................................................. 27
模糊查询% ...................................................................................................................... 29
SQL 通配符 .................................................................................................................... 29
二、python 篇 ................................................................................................................................ 30
python 笔试题-1 ..................................................................................................................... 30
前言 ................................................................................................................................. 30
1.统计 .............................................................................................................................. 31
2.字符串切片 .................................................................................................................. 31
3.字符串切割 .................................................................................................................. 32
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
4.格式化输出 .................................................................................................................. 32
5.队列 .............................................................................................................................. 32
6.交换 .............................................................................................................................. 32
7.水仙花 .......................................................................................................................... 33
8.完全数 .......................................................................................................................... 33
9.排序 .............................................................................................................................. 34
10.sort 排序 .................................................................................................................... 34
python 笔试题(递归)-2 .......................................................................................................... 35
计算 n 的阶乘 ................................................................................................................. 35
斐波那契数列 ................................................................................................................. 37
幂的递归 ......................................................................................................................... 37
汉诺塔问题 ..................................................................................................................... 38
python 编程题-3 ..................................................................................................................... 39
python 编程 4-遍历文件 ........................................................................................................ 41
三、linux 篇 .................................................................................................................................... 42
linux 常用指令-1 ..................................................................................................................... 42
前言 ................................................................................................................................. 42
常用指令 ......................................................................................................................... 42
ps 查看进程 .................................................................................................................... 43
kill 杀掉进程 .................................................................................................................. 43
启动服务 ......................................................................................................................... 43
查看日志 ......................................................................................................................... 44
查看端口 ......................................................................................................................... 44
find 查找文件 ................................................................................................................. 45
测试环境搭建-tomcat ............................................................................................................ 46
测试环境如何搭建? ..................................................................................................... 46
以 jenkins 搭建为例(web 网站搭建都是一个套路) ................................................ 47
前言 ................................................................................................................................. 47
wget ................................................................................................................................. 47
下载 jenkins .................................................................................................................... 47
启动 jenkins .................................................................................................................... 48
四、接口篇..................................................................................................................................... 51
http 协议相关面试题 ............................................................................................................. 52
前言 ................................................................................................................................. 52
浏览器输入 url 按回车背后经历了哪些?................................................................... 52
GET 和 POST 的区别 ....................................................................................................... 52
cookies 机制和 session 机制的区别 .............................................................................. 53
HTTP 状态码 ................................................................................................................... 54
http 协议请求方式 ......................................................................................................... 54
http 和 https 区别 ........................................................................................................... 54
报文 ................................................................................................................................. 55
post 请求 body ............................................................................................................... 55
DNS .................................................................................................................................. 56
无状态 ............................................................................................................................. 56
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
接口测试面试题 ..................................................................................................................... 56
前言 ................................................................................................................................. 56
为什么要做接口测试? ................................................................................................. 56
接口测试能发现哪些问题 ............................................................................................. 57
接口测试怎么测 ............................................................................................................. 58
用什么工具测 ................................................................................................................. 60
webService 接口 ............................................................................................................. 61
没有接口文档如何做接口测试 ..................................................................................... 62
数据依赖 ......................................................................................................................... 62
依赖第三方 ..................................................................................................................... 62
抓包 ................................................................................................................................. 63
弱网 ................................................................................................................................. 63
分析 bug 是前端还是后端的 ......................................................................................... 63
接口自动化面试题 ................................................................................................................. 63
前言 ................................................................................................................................. 63
1.json 和字典 dict 的区别? .......................................................................................... 64
2.测试的数据你放在哪? ................................................................................................ 65
3.什么是数据驱动,如何参数化? .............................................................................. 66
4.下个接口请求参数依赖上个接口的返回数据 .......................................................... 68
5.依赖于登录的接口如何处理 ...................................................................................... 69
6.依赖第三方的接口如何处理 ...................................................................................... 69
7.不可逆的操作,如何处理,比如删除一个订单这种接口如何测试 ...................... 69
8.接口产生的垃圾数据如何清理 .................................................................................. 69
9.一个订单的几种状态如何全部测到? ...................................................................... 70
10.python 如何连接数据库操作? ............................................................................... 70
Mock 相关-单元测试 ............................................................................................................. 71
什么是 mock ................................................................................................................... 71
mock 能做什么 ............................................................................................................... 71
mock 环境准备 ............................................................................................................... 72
依赖关系 ......................................................................................................................... 72
mock-server 环境搭建—加分项! ........................................................................................ 74
前言 ................................................................................................................................. 74
环境准备 ......................................................................................................................... 74
Moco 环境搭建 .............................................................................................................. 74
遇到的问题 ..................................................................................................................... 76
官方文档 ......................................................................................................................... 77
五、selenium 篇 ............................................................................................................................. 78
selenium 中隐藏元素如何定位? ......................................................................................... 78
前言 ................................................................................................................................. 78
隐藏元素 ......................................................................................................................... 78
定位隐藏元素 ................................................................................................................. 80
操作隐藏元素 ................................................................................................................. 80
JS 操作隐藏元素 ............................................................................................................. 81
selenium 面试题 ..................................................................................................................... 82
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
前言 ................................................................................................................................. 82
1.如何判断一个页面上元素是否存在? ...................................................................... 82
2.如何提高脚本的稳定性 .............................................................................................. 83
3.如何定位动态元素 ...................................................................................................... 84
4.如何通过子元素定位父元素 ...................................................................................... 84
5.如果截取某一个元素的图片,不要截取全部图片 .................................................. 86
6.平常遇到过哪些问题?如何解决的 ............................................................................ 86
7.一个元素明明定位到了,点击无效(也没报错),如果解决? ............................ 86
六、app 篇 ..................................................................................................................................... 87
app 测试面试题...................................................................................................................... 87
前言 ................................................................................................................................. 87
1.什么是 activity ............................................................................................................. 87
2.Activity 生命周期? ....................................................................................................... 88
3.Android 四大组件 ........................................................................................................ 90
4.app 测试和 web 测试有什么区别? .......................................................................... 90
5.android 和 ios 测试区别? .......................................................................................... 91
6.app 出现 ANR,是什么原因导致的? ....................................................................... 92
7.App 出现 crash 原因有哪些? .................................................................................... 93
8.app 对于不稳定偶然出现 anr 和 crash 时候你是怎么处理的? ............................. 93
9.app 的日志如何抓取? ................................................................................................. 94
10.你平常会看日志吗, 一般会出现哪些异常(Exception)? ................................... 94
七、jenkins 持续集成-加分项 ....................................................................................................... 95
如何运行代码? ..................................................................................................................... 96
如何新增 slave 节点 ............................................................................................................... 97
如何设置定时任务? ........................................................................................................... 104
如何结合 git 拉取代码? ..................................................................................................... 107
2019 课程推荐 ............................................................................................................................. 108
好书推荐....................................................................................................................................... 109
Selenium+python .................................................................................................................. 109
Python 接口自动化 .............................................................................................................. 110
python 自动化框架 pytest ................................................................................................... 111
Appium+python .................................................................................................................... 111
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
一、SQL 篇
Sql 是必考的基础题,sql 至少需要掌握简单的增删改查,2 表联合查询,排序等常规操作
SQL 学生表-1
常见 SQL 面试题:
1.查询所有学生的数学成绩,显示学生姓名 name, 分数, 由高到低
2.统计每个学生的总成绩,显示字段:姓名,总成绩
3.统计每个学生的总成绩(由于学生可能有重复名字),显示字段:学生 id,姓
名,总成绩
4.列出各门课程成绩最好的学生, 要求显示字段: 学号,姓名,科目,成绩
第一步先 group by 找出单科最好成绩,作为第一张表
5.列出各门课程成绩最好的 2 位学生, 要求显示字段: 学号,姓名, 科目,成
绩
前言
每次面试必考 SQL,小编这几年一直吃 SQ 的亏,考题无非就是万年不变学生表,
看起来虽然简单,真正写出来,还是有一定难度。于是决定重新整理下关于 SQL
的面试题,也可以帮助更多的人过 SQL 这一关。
作为一个工作 3 年以上测试人员,不会 sql 基本上能拿到 offer 的希望渺茫,虽
然平常也会用到数据库,都是用的简单的查询语句。困难一点的就直接找开发了,
面试想留个好印象,还是得熟练掌握,能在纸上快速写出来。
万年不变学生表
有 2 张表,学生表(student)基本信息如下
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
科目和分数表(grade)
排序 order by
1.查询所有学生的数学成绩,显示学生姓名 name, 分数, 由高到低
SELECT a.name, b.score
FROM student a, grade b
WHERE a.id = b.id
AND kemu = '数学'
交流 QQ 群:779429633
测试面试题 上海-悠悠 著
ORDER BY score
DESC
统计总成绩 sum
2.统计每个学生的总成绩,显示字段:姓名,总成绩
SELECT a.name, sum(b.score) as sum_score
FROM student a, grade b
WHERE a.id = b.id
GROUP BY name
DESC
交流 QQ 群:779429633