C#

What types of tasks and projects would you like to focus on in your new job?

Can an abstract method exist outside an abstract class?

Is it possible to use the await construct inside a block where lock is used?

Can you list the main architectural approaches and models used in application development?

What design patterns do you apply in your practice?

What is the purpose of using execution plan descriptions in SQL?

Junior — Middle

OZON

What steps will you take if you notice a decrease in system performance in a production environment?

Junior — Middle

OZON

What are the basic delegates in .NET and how do they differ?

What are the main components involved in the data or system migration process?

Junior — Middle

Andersen

What distinguishes the creation of a clustered index from defining a PRIMARY KEY in SQL?

How to implement the ability to extend the functionality of the system or component?

What is a stack?

When does the mandatory health insurance (DMS) start to be effective?

In which cases should a data warehouse be used for applications?

Junior — Middle

Aston

What is OAuth authentication and how does it work?

What difficulties may arise when implementing the Singleton pattern in a multithreaded environment?

Can you explain what the use of INNER JOIN in SQL queries means?

Can you explain what is meant by thread-safe collections in programming?.

What is the main purpose of using containerization with Docker?

Where is the class definition usually stored in programming?

Junior — Middle

IT One