Why might a server respond to ping but be unavailable over TCP/UDP, for example, via HTTP or FTP?
Middle+
196
Python
11109
584
Challenges of microservices architecture: data consistency, distributed transactions, API versioning.
Senior
196
Why do FastAPI's synchronous handlers execute in parallel in 5 seconds instead of 10?
Middle
196
What tools can be used to determine the type of a variable in Python?
Junior — Middle
196
How is the uniqueness of elements ensured in a set collection?
Junior — Middle
196
What is the significance of the term facilitation in project management?
Junior — Middle
196
Which operator in Python provides automatic resource management using context managers?
Junior — Middle
196
What are the features of the gather function in the asyncio library and what are its advantages in organizing asynchronous operations?
Junior — Middle
196
What disadvantages can be identified in index structures in databases?
Junior — Middle
196
Can you tell about your development experience using JavaScript?
Junior — Middle
196
What are the main elements and modules used in creating deep learning systems?
Junior — Middle
196
How does the concept of a distributed monolith arise in system architecture?
Middle — Middle+
196
Have you participated in helping other team members with their tasks?
Junior — Middle
196
Can you briefly explain the concept of Agile and its main principles?
Junior — Middle
196
Can you explain what Docker technology is and how it works?
Junior — Middle
196
What criteria allow classifying a developer as middle level?
Junior — Middle
196
How are private variables and methods declared inside a class in Python?
Junior — Middle
196
# 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
196
How does a virtual machine differ from a Docker container?
Middle+
196
Explain the working principle of binary search algorithm and its main characteristics.
Junior — Middle
196