C#

Explain the concept of Eager Loading in Entity Framework and when it is used.

Can you explain what a non-clustered index in SQL is and how it works?

Are there any limitations on the number of threads that can be launched on a single process?

Does automatic type conversion occur when comparing two structures in a programming language?

Junior — Middle

OZON

How should error and exception handling be implemented in a program?

Can you explain the concept of two-level caching and its main purpose?

What are the differences between a class and a structure in programming?

What specifically attracted your attention to this position, and why did you choose our project or company?

Is it possible to apply generic method types without encapsulating them in generic classes?

Can you explain what the .NET platform is and what capabilities it offers for application development?

Who can call a method declared with the public modifier?

Why is it important to reduce dependencies between modules in a system?

What is the main role of the Redis database in application architecture?

Can you explain how garbage collection works in programming languages?

What is the purpose of the await operator in asynchronous programming?

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?

What was the composition of the development team at your previous workplace?

Where in memory is a variable of type object usually located?

Junior — Middle

СБЕР Тех