Experienced programmers spent 24 hours finishing the Python face test! A total of 309 lanes!

1. Why learn python?

2. What is the way to learn python?

3.Python vs. Java, PHP, C, C #, C + + and other languages?

4. Describe the explanatory and compiled programming languages?

What are the 5.Python interpreter types and features?

6. What is the relationship between bits and bytes?

7.B, B, KB, MB, GB relationship?

8. Please list at least 5 PEP8 specifications (the more the better).

9. The following conversions are implemented through the code:

Binary conversion to decimal: v = "0b1111011"

Decimal converted to binary: v = 18

Octal into decimal: v = "011"

Decimal into octal: v = 30

16 binary converted to decimal: v = "0x12"

Decimal converted to 16 binary: v = 87

10. Write a function implementation to convert the IP address to an integer.

If the 10.3.9.12 conversion rule is:

32. List common built-in functions?

33.filter, map, reduce the role?

34. One line of code implements 9*9 multiplication table

35. How do I install a third-party module? And what third-party modules have been used?

36. What are some of the 8 common modules that are listed at least?

What is the difference between match and search in 37.re?

38. What is a regular greedy match?

39. Results: A. [I% 2 for I in range] B. (i% 2 for I in range (10))

40. Results: A. 1 or 2 B. 1 and 2 c. 1 < (2==2) d. 1 < 2 = 2

41.def func (a,b=[]) What kind of hole is this?

42. How to achieve "the" "1", ' 2 ', ' 3 '?

43. How do I achieve [' 1 ', ' 2 ', ' 3 '] become [All-in-all]?

44. Comparison: a = [2] and B = [(1), (), (3)] and B = [(1,), (2,), (3,)] the difference?

45. How do I generate [1,4,9,16,25,36,49,64,81,100] in one line of code?

46. A line of code to remove duplicate values from the list?

47. How do I set a global variable in a function?

What is the role of 48.logging module? and application scenarios?

49. Please use the code simple to implement the stack.

50. What kinds of string formats are used?

51. Briefly describe the generator, iterator, iteration object, and application scenario?

52. Use Python to implement a binary lookup function.

53. Talk about your understanding of closures?

What is the function of the 54.os and SYS modules?

55. How do I generate a random number?

56. How do I delete a file using Python?

57. What is your understanding of the opposite to the object?

58.Python What are the characteristics of inheritance in object-oriented?

59. What is object-oriented depth first and breadth first?

60. What is the role of super in object-oriented?

61. Have you used a function in Functools? What is its role?

62. List the special methods of the object-oriented with the cool underline, such as: __new__, __init__

63. How can I tell if it is a function or a method?

What types of data can be processed when 75.json serialization? How do I customize support for datetime types?

76.json serialization, the default encounter Chinese will be converted to Unicode, if you want to keep Chinese?

77. What is an assertion? Application scenarios?

78. Have you ever worked with statement? What are the benefits of it?

79. Use the code implementation to view all the files in the enumeration directory.

80. Describe the yield and yield from keyword.

Part two network programming and concurrency (34 questions)

1. Describes the OSI seven layer protocol.
2. What is a/C and B/s architecture?
3. A brief description of the three-time handshake and four wave-waving process.
4. What is the ARP protocol?
5. What is the difference between TCP and UDP?
6. What are LAN and WAN?
7. Why is TCP protocol-based communication more reliable than UDP-based communication?
8. What is a socket? This paper describes the socket communication process based on TCP protocol.
9. What is a sticky bag? What is the cause of the sticky packet in the socket? What happens when a sticky bag occurs?
10. What is the role of IO multiplexing?
11. What is a firewall and what is the role?
12. What are the differences between select, poll, and Epoll models?
13. Describe the differences between process, thread, and association, and the application scenario?
14. What the hell is a Gil lock?
15. How do I use the thread pool and process pool in Python?
16. The role of threading.local?
17. How is communication between processes?
18. What is concurrency and parallelism?
19. What is the role of process lock and wire lock?
20. Explain what is asynchronous non-blocking?
21. What are the differences between routers and switches?
22. What is domain name resolution?
23. How do I modify the local hosts file?
24. Producer consumer model application scenarios and advantages?
25. What is a CDN?
26. What is LVS and what is the role?
27. What is nginx and how does it work?
28. What is the role of keepalived?
29. What is haproxy and how does it work?
30. What is load balancing?
31. What is RPC and application scenarios?
32. The function and application scenario of Asynio module are briefly described.
33. The function and application scenario of Gevent module are briefly described.
34. Use and application of the twisted framework?

 SELECT * from TB where name = ' Oldboy-wupeiqi ' select * from TB where name = ' Oldboy-wupeiqi ' limit 1 

1. 1000w data, when using limit offset paging, why the more backward climb slow? How to solve?
2. What is an index merge?
3. What is an overlay index?
4. Brief description of database read/write separation?
5. A brief description of database sub-Library sub-table? (Horizontal, vertical)
6. Redis and memcached comparison?
7. How many DB and function does the database default in Redis?
8. Python operating module for Redis?
9. If the amount of data in a list in Redis is very large, what if the implementation loops through each of the values?
10. How does Redis implement master-slave replication? and the data synchronization mechanism?
11. What is the role of Sentinel in Redis?
12. How do I implement a Redis cluster?
13. How many hash slots are default in Redis?
14. What are some of the persistence strategies and comparisons of Redis?
15. Lists the expiration policies supported by Redis.
16. MySQL has 2000w data, only 20w of data in Redis, how to ensure that Redis is hot data?
17. Write code to implement FIFO, LIFO, and priority queues based on the Redis list.
18. How do I implement Message Queuing based on Redis?
19. How do I implement publishing and subscriptions based on Redis? And the difference between a publish subscription and a message queue?
20. What is Codis and function?
21. What is twemproxy and function?
22. Write code to implement Redis transactional operations.
23. What is the function of the Watch command in Redis?
24. How can I implement the mall commodity quantity counter based on Redis?
25. The implementation mechanism of Redis distributed lock and Redlock is briefly introduced.
26. What is a consistent hash? Is there a corresponding module in Python?
27. How to efficiently find all keys in Redis that start with Oldboy?
1. 
   
2. What is the difference between only and defer?
   The difference between select_related and prefetch_related?
   What is the difference between filter and exclude?
   Enumerates three ways to write SQL statements in a Django Orm.
   How do I set up read and write separations in Django Orm?
   The role of F and Q?
   What is the difference between values and values_list?
   How do I batch create data using Django ORM?
   What is the role of Django's form and modeform?
   In the Django form component, if the field contains the choices parameter, use two ways to enable the data source to be updated in real time.
   What is the role of the On_delete parameter in the ForeignKey field in the Django model?
   What is the implementation mechanism of CSRF in Django?
   How does Django implement WebSocket?
   Which method can I use to carry CSRF tokens, based on the way Django uses Ajax to send a POST request?
   How Django creates a log record when adding data to an ORM table.
   How is the Django cache set up?
   Can the Django cache use Redis? If so, how can I configure it?
   What does name do in the Django routing system?
   What is the difference between filter and Simple_tag in a Django template?
   The role of Django-debug-toolbar?
   How do you implement unit testing in Django?
   Explain the meaning of DB first and code first in ORM?
   How does Django generate the classes in model based on the database tables?
   What are the pros and cons of using ORM and native SQL?
   Brief introduction to MVC and MTV
   What is the role of Django's contenttype component?
   What do you know about the restfull norm?
   What does the idempotent of an interface mean?
   What is RPC?
   What is the difference between HTTP and HTTPS?
   Why use the Django Rest framework framework?
   What are the components in the Django Rest framework framework?
   What classes can be inherited by views in the Django Rest framework framework?
   Describes the certification process for the Django Rest Framework framework.
   How does the Django Rest framework implement user access frequency control?
   The advantages of the flask framework?
   Flask Framework Dependent components?
   The role of the Flask blueprint?
   List The used Flask third-party components?
   Describe the flask context management process?
   The role of G in flask?
   What are the relevant classes involved in context management in flask? and describe the main role of the class?
   Why should flask maintain the value stack in the local object as a list?
   How does a multi-app app in flask work?
   What components are required to implement WebSocket in flask?
   What is the role of wtforms components?
   Flask Framework default session processing mechanism?
   Explain the difference between a local object and a Threading.local object in the flask framework?
   What is blinker in flask?
   What is the difference between the session and the scoped_session in SQLAlchemy?
   SQLAlchemy How do I execute native SQL?
   How is ORM implemented?
   What is the function of the Dbutils module?
   Are the following sqlalchemy fields correct? If it is not correct, please correct:
   
   

From datetime import datetimefrom sqlalchemy.ext.declarativeimport declarative_basefrom sqlalchemy import Column, Integer, String, datetimebase = Declarative_base () class UserInfo (base): __tablename__ = ' UserInfo ' id = Column (Integer, PR Imary_key=true, autoincrement=true) name = Column (String, unique=true) ctime = Column (DateTime, default= DateTime.Now ())

How do I set the engine and character encoding for a table in 87.SQLAchemy?

How do I set a federated unique index in 88.SQLAchemy?

89. Briefly describe the characteristics of the Tornado framework.

90. Describe the role of future objects in the Tornado framework?

How do I write websocket programs in the 91.Tornado framework?

How is static files handled in 92.Tornado? such as: <link href= "{{Static_url (" Commons.css ")}}" rel= "stylesheet"/>

93.Tornado operating the module used by MySQL?

94.Tornado operating the module used by Redis?

95. Describe the application scenario of the tornado framework?

96.git Common Command functions:

97. Briefly describe the following git stash commands and related other commands.

The difference between the merge and Rebase commands in 98.git.

99. How does co-development work with Git?

100. How do I implement code review based on Git?

101.git How to achieve v1.0, v2.0 and other versions of management?

102. What is Gitlab?

What is the difference between 103.github and Gitlab?

104. How do I contribute code to a great open source project on GitHub?

What is the role of the. gitignore file in 105.git?

106. What is Agile development?

107. Describe the role of the Jenkins tool?

108. How does the company implement the code release?

109. Describe the difference between RabbitMQ, Kafka and zeromq?

110.RabbitMQ How to keep the data from being lost when the customer gets the task and hangs up before it is processed?

111.RabbitMQ How do I persist messages?

How does 112.RabbitMQ control the order in which messages are consumed?

113. What does the following RABBITMQ exchange type mean? such as: fanout, Direct, topic.

114. What is celery and what is the application scenario?

115. Briefly describe the operating mechanism of celery.

116.celery How do I implement timed tasks?

117. Brief description of the celery multi-task structure directory?

118.celery decorator @app. What are the differences between task and @shared_task?

119. Briefly describe the function and basic use of the requests module.

120. Briefly describe the function and basic use of the BeautifulSoup module.

121. Briefly describe the function and basic use of the Seleninu module.

The workflow of the components in the 122.scrapy framework?

123 How do I set up the proxy (two methods) in the Scrapy framework?

How do I download large files in the 124.scrapy framework?

How to achieve speed limit in 125.scrapy?

How to implement tentative crawler in 126.scrapy?

How do I customize commands in 127.scrapy?

How to achieve the depth of the crawler in 128.scrapy?

How does the pipelines work in 129.scrapy?

How does the 130.scrapy pipelines discard an item object?

131. Describe the role of crawler middleware and download middleware in Scrapy?

What is the role of 132.scrapy-redis components?

How does the 133.scrapy-redis of a task in a component be implemented?

How does the 134.scrapy-redis scheduler implement the task's depth first and breadth first?

135. Describe vitualenv and application scenarios?

136. Describe pipreqs and application scenarios?

137. What code-checking tools are used in Python?

138. Describe the role of saltstack, ansible, Fabric, puppet tools?

What is the difference between 139.B tree and B + tree?

140. Please list common sorts and implement any three of them by code.

141. Please list common lookups and implement any three of them by code.

142. Please list the design patterns you are familiar with?

143. Have you ever brushed a leetcode?

144. List the familiar Linux commands.

145. What is the system on the company's online server?

146. Explain the meaning of PV and UV?

147. Explain the meaning of the QPS?

What is the difference between 148.uwsgi and Wsgi?

The role of 149.supervisor?

150. What is a reverse proxy?

151. Describe the entire process of SSH.

152. Are there any questions to find a solution?

153. Are there any technical categories of public numbers to follow?

154. What new technology is being researched recently?

155. Have you learned about domain-driven models?

Statistics: 80 + 34 + 46 + 149 = 309 questions

If there is a great God all will say, remember to give me a message Oh! Small part of the temporary not all out, get out and share to everyone!

Incoming group: 125240963 to get dozens of sets of PDF books Oh!

Experienced programmers spent 24 hours finishing the Python face test! A total of 309 lanes!