C#

What definition does SQL give for the process of collecting and analyzing data based on statistical methods?

Junior — Middle

OZON

Can you explain the concept of multi-layer architecture in software system development?

What are the advantages and disadvantages of static typing in programming languages?

Is it possible to use the await operation inside a critical section protected by a lock?

Have you had practical experience working with source code analysis tools?

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

Can you explain what a nested query in SQL is and when it is used?

In what situations is it recommended to use the using operator in code?

Can you explain the HTTP PUT method and its role in server interaction?

In which cases is it recommended to use abstract classes in object design?

How to distinguish a wide tree data structure from a binary tree by their features?

What does it mean that a controller implements REST principles and how to define a RESTful controller in a project?

Junior — Middle

Aston

Can you explain what the use of Fluent API means in API development?

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

How is the processing of multiple simultaneous requests handled within a single-process Scoped context?

Can you explain how the request processing pipeline mechanism works in ASP .NET?

Can you name the existing levels of transaction isolation in database management systems?.

How can you most effectively combine multiple strings in programming?

Can you explain what a query execution plan in a relational database is?

What are thread-safe collections and how do they work in multithreaded programming?