秋招面经 | 721开发测试面经

7.21开发测试面经

• sql语句

  表结构

  ​ 表名：student
  ​ 字段：id name score

  问题：成绩倒数第二/正数第二的学生名字

  SELECT student.name, student.scores FROM student ORDER BY scores DESC LIMIT 1, 1

  SELECT student.name, student.scores FROM student ORDER BY scores ASC LIMIT 1, 1

• 内外连接

  SELECT student.name, student.scores, class.id FROM student INNER JOIN class ON student.classid = class.id

  SELECT student.name, student.scores, class.id FROM student LEFT JOIN class ON student.classid = class.id

  SELECT student.name, student.scores, class.id FROM student RIGHT JOIN class ON student.classid = class.id

• selenium定位元素

  driver.find_element_by_xpath()
  driver.find_element_by_name()
  driver.find_element_by_tag_name()
  driver.find_element_by_link_text()
  driver.find_element_by_partial_link_text()
  driver.find_element_by_class_name()
  driver.find_element_by_css_selector()
  driver.find_element_by_id()

• tcp三次握手?握手的时候怎么确认对方的身份？
  

• TCP四次挥手
  

• 网络七层模型及各层常见协议
  

• 算法

  • 两数之和

    class Solution(object):
    
    	def twoSum(self, nums, target):
    
    		hashtable = dict()
    		for i,num in enumerate(nums):
    			if target - num in hashtable:
    				return [hashtable[target-num], i]
    			hashtable[nums[i]] = i
    		return []

  • 实现LRU
    LRU