C#

How can you determine the department with the highest average salary in the employee table?

Explain the concept of multithreaded task execution and its main advantages.

How do you organize the process of exporting tables from a database?

Can you explain what the iterator design pattern is and how it is applied?

What is the difference between the IEnumerable and IQueryable interfaces, and in what scenarios are they used?

Can you explain the concept of a class in object-oriented programming?

Can you explain the concept of the mediator pattern and its role in managing object interactions?

Can you tell about your experience with database management systems in projects?

Junior — Middle

AstonSector Tree

Can you explain what generic types are in programming?

Explain what are data types that store references to objects in memory, and how they differ from value types.

What thread synchronization tools have you used in your projects and how did you implement them?

Junior — Middle

СБЕР ТехSector Tree

How to extract a list of departments and their average salaries from a table containing fields for name, department, and salary?

What tools or approaches will you use to update the database table structure?

Have you had experience working with event mechanisms and their handling in a project?

What methods of working with databases do you know?

What is the difference between using class inheritance and implementing interfaces in object-oriented programming?

Explain what anonymous functions or lambda expressions are in programming.

What is finally?

Can you name the main methods available in the Object class object?

Can you explain how the IQueryable interface in .NET works and how it is used to form data queries?