C#

When is the absence of an index in a database justified and recommended to avoid creating it?

Describe your practical skills and approaches to improving the performance of applications you have worked with.

Can you explain the main differences between monolithic, service-oriented, and microservices architectures?

Explain the concept of reflection in programming and its main applications.

Is it possible to use mock objects to simulate context during testing?.

Explain how the use of asynchronous operations differs from multithreading in programming.

Explain what semaphores are and how they are used in thread management in programming.

Junior — Middle

OZON

A colleague's task has come to your Code Review What problems do you see in the code?

How to remove duplicates from an array? What methods are there?

Senior

СБЕР

Can you explain what is meant by a query execution plan in SQL and why it is needed?

Junior — Middle

OZON

What application programming interfaces (APIs) have you had to use in your practice?

Can you explain what the IReadOnlyList interface in C# is and how to use it?

Is programming included in the list of mandatory skills during training?

How does the automatic memory management mechanism detect objects that are no longer accessible in the program?

Junior — Middle

СБЕР Тех

Have you dealt with microservices-based architecture?

Junior — Middle

OZON

Can you explain the differences between value and reference data types?

What is the purpose of attributes in programming or system modeling?

What types of table joins are you familiar with in SQL?

Can you show an example of using LINQ to perform queries on a collection?

Could you list the main types of classes in object-oriented programming?