Could you explain the purpose of the IDisposable interface and how to use it in resource management?
167
C#
How do the concepts of asynchronous operations and parallel task execution differ?
Junior — Middle
166
Is it possible to conceptually evaluate and compare any objects in C#?
Junior — Middle
166
Formats and methods of inter-service interaction.
Middle
165
Can you explain what is meant by a query execution plan in SQL and why it is needed?
Junior — Middle
164
How do you analyze and interpret performance metrics in SQL queries?
Junior — Middle
164
Can you list the different types of indexing used in database systems?
162
Can you share your experience working with different types of databases, their features, and applications?
161
Describe your last work experience and main responsibilities at your previous job.
Junior — Middle
161
What types of indexes have you used in your SQL queries to optimize data search?
Junior — Middle
161
Name two principles of SOLID, give examples of their violations.
Middle
160
What is SOLID?
Middle+
160
Where do you see yourself in five years?
Middle+
159
Can you explain the concept of a package in programming and how it is used?
Junior — Middle
158
There is a slow SELECT query that has been taking longer to execute over time. How would you diagnose the problem?
Middle
158
Explain the difference between using value types and reference types as keys in a typical dictionary data structure.
Junior — Middle
157
Do you have experience implementing and using the Saga pattern in microservice architecture?
Middle — Middle+
157
Task: You are asked to review the code of a new feature that allows booking a tour (consisting of a flight ticket and a hotel). The feature for separate booking of a flight ticket and a tour already exists, and this task expects a unified method that books either the entire tour or none of its components.
Middle+
157
Do you specify if you have any special preferences or requirements for the future role?
Junior — Middle
156
Pros and cons of monolithic and microservices architecture.
Middle
154