C#

Why is Redis preferred for data storage over storing data directly in the application?

Can a static method be called for a specific instance of a class, and what does its belonging mean?

Can you explain the concept of concurrent processes in multithreading?

What are the differences between passing by value and passing by reference when passing arguments to a function?

How does the index mechanism accelerate query execution in SQL databases?

What are the advantages of using a list over an array?

Can you list different levels of transaction isolation in databases and explain their differences?

How does the call stack state change at the moment of method execution in C#?

What structure and components does the MVVM pattern include?

What are the advantages and disadvantages of the .NET platform?

What types of indexes have you used in your SQL queries to optimize data search?

Junior — Middle

OZON

What is the purpose of calling Task.Run in asynchronous programming?

What are the main recommendations and limitations when creating indexes in SQL systems?

Is a delegate in programming language a reference type or a value type?

How is the CORS policy checked in browsers?

Junior — Middle

Andersen

Can you explain the concept of index fragmentation in a database and how it affects performance?

Explain what idempotency means in the context of HTTP POST requests.

Can you explain the principles of the Service Locator pattern and its purpose?

Where in memory are reference type objects usually located?

Junior — Middle

Andersen

Have you had practical experience creating queries that combine data from multiple tables or sources?