Comprehensive Python and Software Engineering Interview Question Guide

This document is organized into four major parts:

Part 1 – Python Basics (80 questions) includes why learn Python, differences between Python and other languages, binary/decimal/hex conversions, IP‑to‑integer conversion, recursion depth, common built‑ins, PEP8 rules, *args/**kwargs, decorators, generators, OOP concepts, and many short coding tasks such as:

v = "0b1111011"
int(v, 2)

def ip_to_int(ip):
    return sum(int(octet) << (8 * i) for i, octet in enumerate(reversed(ip.split('.'))))

Part 2 – Network Programming & Concurrency (34 questions) covers OSI model, TCP/UDP differences, socket programming, TCP three‑way handshake, sticky packets, I/O multiplexing, process vs thread vs coroutine, GIL, thread pools, process pools, inter‑process communication, async/non‑blocking, and related Python modules.

Part 3 – Databases & Caching (46 questions) addresses relational and NoSQL databases, MySQL engines, normalization, transactions, indexing (including left‑most prefix rule), query execution plans, read/write splitting, sharding, Redis data structures, persistence strategies, sentinel, clustering, distributed locks, and example SQL snippets such as: SELECT * FROM tb WHERE name='Oldboy-Wupeiqi' LIMIT 1; Part 4 – Frontend, Frameworks & Other Topics (155 questions) spans HTTP/HTTPS, WebSocket, AJAX, Vuex, routing guards, CORS, RESTful principles, Django/Flask/Tornado comparisons, ORM usage, middleware, testing, CI/CD tools (Git, Jenkins, Docker), message queues (RabbitMQ, Kafka), container orchestration, security basics, and many practical coding challenges.

Each section lists concise questions and, where relevant, short code examples wrapped in

tags, providing a ready‑to‑use reference for interview preparation.