C#

How does the use of indexes affect the speed of SQL query execution and overall database performance?

What is the reason for using different memory segments to store objects instead of combining them into one area?

Junior — Middle

OZON

Can you explain how dynamic memory management works when using the heap?

How is the management of roles and rights of participants implemented in your project?

Junior — Middle

Aston

Can you explain what strong associations between objects in a system mean?

Explain what is meant by an abstract method in object-oriented programming

What is the purpose of duck typing in C#?

What other paradigms and approaches to software development have you used besides object-oriented programming?

When will you seek support when encountering complex tasks?

Explain the principles underlying the SOLID concept and their impact on software system development.

Can you name the database management systems you are familiar with?

What are the main difficulties encountered when working with databases and how do you solve them?

How was the process of transferring features to testing and interaction with the tester organized?

Middle

Ozon Fresh

What is the difference between using an abstract class and an interface when defining contracts for classes?

Explain the purpose and operation of a constructor when creating a new object in object-oriented programming

Can you give an example of using polymorphism in programming?

How do the keywords const and readonly differ in programming, and in which cases is their use preferable?

Which aspects and experiences at your last workplace were particularly memorable or satisfying?

What is your experience in testing and optimizing high-traffic systems?

Have you had experience working with authorization filters in applications?