C#

Have you worked with MS SQL Server database in your practice?

In which cases is it necessary to independently free the memory allocated for data?

Can you tell about your experience applying the CQRS pattern in projects?

Have you had experience working with design patterns in your projects?

Have you looked into the implementation of LINQ methods and do you understand how they work?

Describe your practical experience using SQL in projects

Explain the differences between a mock object and a stub in software testing.

Junior — Middle

Aston

When can using an index lead to a decrease in SQL query performance?

What is the main difference between HTTP methods PUT and POST when sending data to the server?

Can you explain what is meant by generations in the mechanism of automatic memory management (garbage collection)?

Junior — Middle

Andersen

appfox

What types of operations and commands can be performed in PostgreSQL?

Can you name the main dependency life cycles in project or system management?

How does the discussion and analysis of tasks with the team at the workplace occur?

Can you explain what the 'Builder' pattern is and in what cases it is used?

What types of LINQ queries do you know and what are their differences?

What prompted you to consider changing your current job?

Junior — Middle

OZON

Can you explain what the partial keyword means in C# and when it is used?

Explain the concept of generation in a memory management system and its role in garbage collection.

How was it possible to reduce the response time from 0.5 ms to 0.2 ms?

In what cases is a variable considered dynamically allocated in heap memory?