Can you list the types of collection data structures you are familiar with?
Junior — Middle
231
Python
10975
584
Can you explain the purpose and use of the HAVING clause in SQL queries?
Junior — Middle
202
Can you explain the differences between asynchronous execution, multithreading, and multiprocessing approaches in programming?
192
Share your professional experience and skills that you believe are relevant for this position.
Intern — Junior
192
What salary range do you expect for this position?
Junior — Middle
187
What is the role of indexes in a database and how do they help speed up query execution?
Junior — Middle
182
What is the difference between the use of HAVING and WHERE conditions in SQL?
Junior — Middle
178
What distinguishes the built-in sort function from a method that returns a sorted copy of a collection?
Junior — Middle
174
Can you list the main types of table joins in SQL and explain their differences?
Junior — Middle
170
Explain the difference between the operators == and is in the context of comparison in Python.
Junior — Middle
170
What are the differences between the concepts of asynchronous programming and parallel execution of tasks?
Junior — Middle
166
Explain how object comparison is implemented via __eq__ when these objects are used as keys in a dictionary.
Junior — Middle
163
How does creating a unique index differ from defining a primary key in a database?
Junior — Middle
163
Describe your experience with using Docker in projects and tasks you have solved with it.
Junior — Middle
162
What is used as a key in a dictionary data structure?
Intern — Junior
157
Explain what GIL is in Python and what role it plays in thread execution.
155
What prompted you to leave your previous position?
Junior — Middle
155
Share how you have used asynchronous programming mechanisms with async/await in your projects.
Junior — Middle
155
When is it preferable to use asynchronous operations instead of threads for executing tasks?
Junior — Middle
154
What actions would you take if you notice that an SQL query is running significantly slower than expected?
Junior — Middle
152