C#

Can properties or fields be declared in an interface?

Можно ли обеспечить ACID при уровне изоляции Read Committed?

How does a program determine the point from which to resume execution after a pause or error?

Explain what unboxing means in programming and why it is needed.

Junior — Middle

OZONЭлисофт

When should indexing be applied in a database?

What does RabbitMQ provide in distributed system architecture?

Where in memory are reference type objects usually stored?

What data type categories are considered important or key in programming?

Tell us about Clean Architecture — how is it structured, layers, dependencies?.

Can you explain what Entity Framework is and what it is used for in development?

There is a slow SELECT query that has been taking longer to execute over time. How would you diagnose the problem?

Middle

OZON

What do HTTP status codes 200, 400, and 500 indicate?

What happens inside the SQL server when a query is executed? How is the result obtained from the query text?

Middle

Pyrus

What storage and data processing optimizations were used for a stream of 3-5 thousand events per second: indexes, partitioning, sharding?

Middle

Альфа-Банк

How much memory is allocated when creating a new HashSet?

Middle

Pyrus

Can you explain how indexes work in PostgreSQL database?

What is a request pipeline (middleware pipeline) in ASP.NET Core?

Senior

СБЕР

Can you give an example of a situation where a task scheduler mechanism is applicable?

Can you explain what is meant by the concept of an array in programming?

Could you explain the concept of the MVVM pattern and its main components?