C#

Are you ready to proceed to the next interview stage?

How is a partial index implemented in a SQL database management system?

It is required to output a list of employees receiving the maximum salary in their department.

What properties and methods are usually included in a class responsible for scene management in a game engine?

Have you worked with the ORM framework Entity Framework in your projects?

What is ASP.NET?

What does it mean for a system to be RESTful?

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 run a separate thread to perform a task?

What is the purpose of the IDisposable interface in .NET and how is it used?

Tell the difference between IEnumerable and IQueryable.

What is the lowest isolation level of transactions implemented in PostgreSQL?

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

Junior — Middle

OZON

How is the equality operator (==) overridden for the String type in your code?

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?

How is the mechanism for waiting for task completion within a thread pool implemented?

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

Junior — Middle

Aston