Python

Have you ever used half-stub connections in your projects?

What happens if you call blocking code inside an async function? What will happen to the event loop?

Senior

amoCRM

What attracted you to development in the server-side area and why did you choose this particular direction?

Junior — Middle

MasterDeliveryСБЕР Центр ИИ

What is a key attribute required for declaring a class in a new program?

Junior — Middle

МТС

What can cause memory leaks if there is a garbage collector?

What is the correct way to issue banknotes — why should they be issued in the largest denominations possible?

Senior

Яндекс

How was the code review process organized in your previous project?

How are methods resolved in Python with multiple inheritance (MRO)?

Middle

СБЕР

What is the purpose of Kafka system and in which scenarios is it used?

Are you ready to work from the office and what are your requirements for the work schedule?

Explain what is meant by the term 'closure' in programming.

Junior — Middle

WildberriesНорси-ТрансООО Корпорация ЗНАК+1

In which cases should asynchronous programming be used to solve problems?

In which cases would you prefer Django, and in which FastAPI, and how to divide responsibilities?

What is a subnet mask and why is it needed?

# 3. Write a simple decorator that measures the execution time of a function # 4. Given: two tables # CREATE TABLE departments ( # id SERIAL PRIMARY KEY, # name VARCHAR(100) NOT NULL # ); # CREATE TABLE employees ( # id SERIAL PRIMARY KEY, # name VARCHAR(100) NOT NULL, # department_id INT NOT NULL REFERENCES departments(id), # salary NUMERIC(10,2) NOT NULL # ); Task: # Write a query that outputs department names and their average salary, but only for departments where the average salary is higher # than the average salary across all employees in the company. Sort the result by descending average salary.

How is the analysis and evaluation of task complexity performed when interviewing a developer candidate?

What are the differences between hash table data structure and B-tree?

Can you explain the concept of aggregation in object-oriented programming?

What are the main principles to consider when forming a team for a project with a full lifecycle?

Which library is used to implement the mechanism of launching and waiting for data transfer?