Python interview (3) and python interview

Python interview (3) and python interview
I. Language

1. Is it recommended to read the best python book? Open the topic.

2. What about python decorator, iterator, and yield?

3. Which queue is secure for standard library threads? Which one is insecure? Is logging thread-safe?

4. What are the applicable scenarios of python? What if I encounter computing-intensive tasks?

5. What is the high concurrency solution for python? I want to hear twisted-> tornado-> gevent, and it's better to get to golang and erlang.

Ii. Operating System

We can directly think of it as linux. After all, most of the backend systems are dealing with linux.

1. What is the difference between tcp and udp? What is the tcp stick package? How can this problem be solved? Udp sticky package

2. What is time_wait? What are the possible causes of excessive close_wait attacks?

3. What is the difference between epoll and select? What is the difference between edge triggering and horizontal triggering?

Iii. Storage

The storage may contain rdbms, nosql, and cache. I use mysql and redis as an example.

Mysql Problems

1. About mysql character sets and sorting rules?

2. What is the difference between varchar and char? Size limit? Maximum number of characters that can be stored in varchar in the utf8 Character Set

3. What is the difference between primary key and unique?

4. What are the usage of Foreign keys? Should I use them? Do foreign keys need to be indexed?

5. What is the difference between myisam and innodb? What is the two-phase locking protocol of innodb?

6. What is the purpose of indexing? What is the general principle? What are precautions for designing indexes?

Redis Problems

1. In what scenarios is redis used? Why is mysql not suitable?

2. About redis transactions? Use transactions to simulate atomic + 1 Operations? Are there other solutions for atomic operations?

3. What if redis memory is full?

Iv. Security

Web Security

1. How does one prevent SQL injection?

2. How can xss be prevented? Can xss be avoided after htmlescape?

3. What is csrf? How does django prevent it?

Password Technology

1. What is group encryption? What are the encryption modes? What is the difference between ecb and cbc models? Why do we need an iv vector?

2. What is the https process?

3. What is the difference between symmetric encryption and asymmetric encryption?

4. How to generate a shared key? How can we prevent man-in-the-middle attacks?

V. Miscellaneous

1. Do you want to focus on new technologies? Do golang and rust know about it? Numpy, what is pandas?

2. Keep up with the times? Do you want to go around Weibo?

    

You may think these questions are fine, but many of them are common and need to be solved. The details are more specific to one person. If you think of kiss, you are welcome to look for him at zhihu, they think it's a problem. What are they waiting for? Read more books.

1. Python reference manual, which definitely takes you to the next level

2. Graphic password technology, the best choice for getting started with passwords
   

3. The fifth version of mysql technology insider is a bit thick enough to read the manual. Be patient and read high-performance mysql is strongly recommended.

4. Valid TCP/IP programming