Python

Can you explain what is meant by architecture in the context of systems and software?

What level of complexity can be considered for hash indexes?

How much commercial experience do you have specifically with Python?

Middle+

Simbirsoft

How to determine the time complexity of retrieving the last element from a list in Python?

Junior — Middle

VK

In which cases is it advisable to use denormalization in a database structure?

Could you explain the concept of layers in Docker and how they affect image creation?

What are the advantages and disadvantages of using OFFSET and LIMIT for implementing pagination in SQL queries?

What is GIL in CPython, how is it implemented, and why is it needed?

How do set and list collections differ in their work and usage in Python?

What was your purpose for using Apache Airflow? Why did you choose it specifically?

Middle

СБЕР

What parameters do you rely on when deciding between multiple job offers?

Can you explain what it means to use None in Python?

999999 in range(1,99999999) What is the time complexity of this expression?

Middle

Лига Цифровой Экономики

What are the requirements for an object to be used as a key in a dictionary?

Why are multiple FROM commands used in a Dockerfile sometimes?

How did you determine the scope of work and the volume of tasks in your previous position?

Junior — Middle

Рунити

[name] asked: Is it correct that nonlocal allows an inner function to access a variable from an outer function?

Senior

ivi

When to use SELECT FOR UPDATE and when to use UPDATE ... RETURNING? Provide business examples.

Have you worked with the concept of clean architecture in projects?

What is a static analyzer and linters?