C#

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?

Explain what a mutex mechanism is and how it is used in multithreaded programming?

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?

How can you call an asynchronous function from a synchronous method?

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

Explain what a single thread of execution in a program is and how it works.

Can you list the main types of table joins in SQL and briefly describe their features?

What are the advantages and disadvantages of using containers in .NET platform applications?

What database tools did you use directly in your previous company?

Junior — Middle

ПИК Digital