C#

Can you list and explain the main SOLID principles applied in object design?

What security measures prevent SQL injection in a web application?

Describe your experience with writing and optimizing SQL queries in your projects.

Explain what a relational database is and how it is structured.

Are there any restrictions when adding new features to this method?

How does the async keyword and await operator work in C#?

Какую проблему решает пул потоков (ThreadPool) в C#?

Could you list different types of indexes used in databases?

Junior — Middle

Aston

Have you ever been criticized, for example during code review?

What levels of abstraction would you apply when designing a game engine for a shooter?

What is the difference between a static method and an instance method?

What is the difference between an abstract class and an interface?

What is the purpose of using asynchrony in programming?

Provide an example of implementing the 'Builder' design pattern in C#.

What is a predicate in the context of C# programming?

What is the difference between a struct and a class in C#?

Can you explain the difference between stack and heap in memory management?

Junior — Middle

OZON

What are generic types in C#?

Why are non-relational databases needed?

Have you used transaction management mechanisms in SQL databases in your projects?