Python

In what situations is it preferable to use tuples in Python?

How did you balance fulfilling your main responsibilities with learning new skills or knowledge?

Given three tables: 1. Users: - id (user's unique identifier). - name (user's name). 2. Courses: - id (course's unique identifier). - name (course name). - price (course cost). 3. Student courses: - id (record's unique identifier). - student_id (user's identifier). - course_id (course's identifier). Required: List all users who bought courses totaling more than 10,000, in the format: - user_name (user's name). - total_price (total purchase amount). Starting code select * from users limit 10; select * from courses limit 10; select * from student_courses limit 10;

Can tuples with multiple elements be used as keys in a dictionary?

What are the main aspects to consider when forming a managerial role in an organization?

When exactly does the __iter__ method activation occur during iteration over an object?

Have you had experience using SQLite in your projects?

What are the advantages and disadvantages of using relational databases?

Have you used the dataclass decorator in your projects?

Junior — Middle

AstonTechCore

There is an application that reads a large stream of values (millions). It is necessary to quickly check if a specific value is in the list of processed ones. What collection to use?

Can you explain the purpose of context managers in Python and how they work?

When is it advisable to use a synchronous approach in programming?

What steps and methods have you used to join and adapt to a new project?

Have you used the yield from construct in Python for delegating generators?

How to distinguish between weak and strong references in Python and what are their differences?

What prompted you to leave your previous project?

Tell about a case where you independently proposed an improvement to simplify the workflow.

What are the main difficulties that may arise when using queues in data processing systems?

How to organize a team that handles all stages of development — from API endpoint development to deploying the application in a production environment?

What is the role of the slots method and what advantages does it provide in resource optimization?