At the end of 2017, several python back-end interviews

Source: Internet
Author: User
Tags mysql query

Pre-record: 16 years of Undergraduate graduation, selected a large company's QA, work after a period of time to find more like to do development, and then embarked on the road of transfer, in a small company after half a year of development, because of the company's reasons, so began the difficult to cast resumes interview road. Near the end of the year, job opportunities are not many, the following record part of the interview company, because these are not all asked what, unified written in one. There were other articles documenting the interviews of the remaining companies.

1. Shell

Phone interview:

    1. Talk about the three-time TCP handshake, four waves, why is this?
    2. HTTP security for the understanding of the sex, say a bit about the cookie and session understanding;
    3. For MySQL, what's the difference between the types of data you use, char and varchar?
    4. Tell me about threads, processes, and co-routines. How is the implementation of the co-process?
    5. If you implement a chat room, different people send messages how can everyone see? HTTP long links are required.
    6. Say a little bit about Redis.

Summarize:
Interview my husband is very good, in the process of the problem will also give a certain answer, finally set the scene interview for three o'clock in the afternoon, because the morning of the interview millet has been face to the fast three o'clock, did not go to the scene, very pity!

2. Headlines

Side:

    1. Direct a handwritten algorithm problem, n patient's doctor time, try to divide the average to m a doctor, ask each doctor to divide the time is how much;
    2. A database, every 10 minutes will receive the millions data to insert, how should design?
    3. Also asked a few other questions, relatively simple, can't remember;

Two sides:

    1. Asked a how to design performance test platform;
    2. Asked if I would like to do the test, I still hope to do the development, it is over.

Summarize:
Headline interview performance is not good, on the one hand the reason is the weak foundation of their own algorithm, another of their own work experience is not enough, especially for high concurrency and so on their own before useless, completely a face Meng force.

3. Start-up companies

Side

    1. Fibonacci sequence, I wrote the generator version, and then let's write a recursive version;
    2. Input ' 22+33 ' such a string, with object-oriented implementation, as far as possible to consider extensibility;
    3. HTTP status Code;
    4. TCP Three-time handshake, etc., other forget;

Two sides:

    1. A multi-child node tree, how to design a data table to store such data?
    2. Write out the MySQL query statement.
    3. Talk about the process, thread, the understanding of the association;
    4. Why is the process implemented?
    5. I can't remember the other questions.

HR Face:
Since the end of the two side of the HR is not, then the telephone interview conducted, mainly asked some basic situation, talk about the next treatment or something.

Summarize:
The company gave a slightly lower treatment, can not match the size of week work time, and the company's technical staff is a little less, worried into the pit, the offer refused.

4. Go out and ask

Side:

    1. Single linked list inversion, programming implementation;
    2. The problem of a global variable and a partial variable, and the result of the output after re-assigning the value in the function;
    3. The inheritance problem of the new class;
    4. HTTP protocol;
    5. Non-recursive implementation of two-fork tree in the middle sequence traversal;

Two sides:

    1. MySQL optimization problem, how to optimize in the work;
    2. Say or draw a picture of your current project main structure chart, main data table;
    3. Redis problem;
    4. Talk about the understanding of restful;
    5. The other can't remember, about a total of 1 hours;

Three sides:

    1. A system design problem, forget what system, need to design which tables, provide which interfaces;
    2. Asked a number of questions in the project;
    3. Other can not remember, feel the opportunity, I asked the next company on the position of the demand and large problems;

HR Face:

    1. Reasons for leaving the office;
    2. Casually chat about the content, about the next day to talk about the pay treatment;

Summarize:
Get an offer, pay satisfaction, also ready to go, but did not in the appointment date before the current company to finish leaving, regret missed, feel very sorry HR small sister.

5. Tenderness

Side

    1. Written question 1: Three tables of Data link query, the specific contents are not clear;
    2. Written question 2: programming to implement their own lists, a single linked list problem;
    3. Asked a few questions about Redis;
    4. Asked the operating system for file operations, will need to what steps;
    5. Other questions probably talked about it;

hr

    1. One side of the time is very late, and HR probably chatted, told me that the right back will contact, and then withdrew. However, there is no contact!

Summarize:
And did not send a tenderness resume, and then finished without results, embarrassed.

6. Summary

The above is the interview of several companies still remember the problem, there are also know and Xiaomi interview did not tidy up, plus before Sogou interview, follow-up will be collated, and complete summary.

At the end of 2017, several python back-end interviews

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.