Explain the Index Only concept and how it affects query execution in databases.
Junior — Middle
191
Python
11109
584
What is meant by full-text search in databases?
Junior — Middle
191
What problems does cache have?
Middle
191
When is it preferable to use asynchronous operations instead of threads for executing tasks?
Junior — Middle
191
Do you perform your work remotely or on-site at the office?
Intern — Middle
191
Can you explain what is meant by the concept of a function in programming?
Junior — Middle
191
Could you tell who was responsible for designing the database schema at your last workplace?
Junior — Middle
191
Have you suggested or initiated improvements in work methods or procedures?
Junior — Middle
191
What key responsibilities and skills are considered necessary for an effective development team leader?
Middle — Middle+
191
Can you explain the concept of connectivity or relationship between system components?
Junior — Middle
191
What are transactions and isolation levels in PostgreSQL?
Middle
191
What types of resource management mechanisms exist in Python?
Junior — Middle
191
What methods can be used to output messages or errors to the standard error stream (stderr)?
Junior — Middle
191
What difficulties arise when using lists in Python in terms of memory management?
Junior — Middle
191
Tell me about ACID. Especially about transaction isolation levels. Which level did you use?
Middle
191
What is the difference between HAVING and WHERE in SQL?
Middle
191
What are the advantages of using asyncio for asynchronous operations compared to threads in terms of performance?
Junior — Middle
191
How much commercial experience do you have specifically with Python?
Middle+
191
Could you tell about your previous professional tasks and work experience?
Junior — Middle
191
How can you measure the execution time of an SQL query?
Junior — Middle
191