What do you do if you realize you won't meet the deadline for a task?
Middle+
135
Python
10983
584
How do you assess the deadlines for completing a task? Have you ever experienced a situation where your estimate differed from reality?
Middle+
134
How to create a decorator that works with both synchronous and asynchronous functions?
Middle
134
How often do you use type annotations in Python? Do you want to type it in a way that mypy won't complain?
Middle
134
What do you think, which questions do specialists start asking themselves only with experience?
Middle+
133
Tell us if you have experience working in conditions of high uncertainty (new team, processes not set up)? How do you feel about it, does it scare you?
Middle+
132
Describe a situation where you disagreed with the decision of a team lead or senior developer. What was it and how did you defend your position?
Middle+
131
What is a coroutine? How does a Task differ from a coroutine?
Middle
129
How do you work under load, under pressure? Does it pressure you, or do you organize everything according to plan?
Middle+
128
How to ensure the preservation of dialogue history when restarting the WebSocket server?
Middle
128
What motivates you and what demotivates you at work?
Middle+
126
# 3. Write a simple decorator that measures the execution time of a function
Middle
126
What is the base metaclass in Python?
Middle
124
Why can a tuple be a key in a dictionary, but not a list? What types can be keys in general?
Middle
123
How do you explain complex technical solutions to non-technical specialists (designers, project and product managers)?
Middle+
123
# 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.
Middle
122
After which situations do you find it important to revisit and rethink your decisions?
Middle+
122
How do you learn new technologies and tools? Is there a plan (roadmap) or is it situational? Give an example of what you have learned in the last six months.
Middle+
121
Was there a case when you discovered a bug (your own or someone else's) after the release? What did you do?
Middle+
120
Explain the Dependency Injection pattern and what problem it solves.
Middle+
120