Explain the purpose and use of the IDisposable interface in .NET.
Junior — Middle
187
C#
Tell about your experience optimizing complex SQL queries and working with execution plans. Was there a case where you managed to speed up a query 2-3 times?
Middle
186
What is the role of the Equals method when working with keys in a Dictionary collection?
Junior — Middle
184
How is the efficiency of key-based search evaluated in different data structures?
Junior — Middle
182
Can you name the main types of indexes used in SQL database management systems?
Junior — Middle
182
How long can the process of changing jobs to a new position take?
Junior — Middle
182
What are the ways to allocate significant types in managed memory (heap)?
Junior — Middle
182
How to optimize the Enrich method for 10 million events with different IDs? How to limit parallelism?
Middle+
180
What stages of development can be distinguished in the life cycle of objects in managed memory?
Junior — Middle
180
What is the basis for storing objects in dynamic memory rather than in the automatic stack?.
Junior — Middle
180
What are the main differences between parallel and asynchronous task execution?
Junior — Middle
179
Explain the difference between reference and value types.
Middle
179
Can we use await inside a lock block?
Middle
179
What is the difference between using LEFT JOIN and RIGHT JOIN when joining tables in SQL?
Junior — Middle
178
How do you feel about the prospect of communicating directly with the business?.
Middle+
178
What objects in .NET fall into the Large Object Heap and how can they be identified?.
Junior — Middle
177
What is the difference between LEFT JOIN and RIGHT JOIN in SQL and when are they used?
Junior — Middle
177
Are data considered important always placed in the dynamic memory allocation area?
Junior — Middle
177
Have you had practical experience implementing asynchronous processes in projects?
176
Have you worked with container orchestration tools like Kubernetes?
Junior — Middle
176