C#

Can you explain the concept of multithreading and its application?

How can a many-to-many relationship be organized between entities in a database?

Explain what is meant by the concept of Records in programming language

Junior — Middle

IT One

How can you continue executing an asynchronous function after it is interrupted or when work resumes?

Junior — Middle

OZON

What methods can be used to implement safe resource locking inside a class?

Explain the purpose and operation of the CancellationToken object in the context of asynchronous programming.

Can you explain the concept of bit flags in SQL and how they are used to store multiple boolean values in a single column?

Can you explain the main principles of RESTful API architecture?

Have you ever used procedural approaches in your projects?

Can you explain what a pattern is in software development?

Explain what attributes are in C# and how they are used in development.

How do you analyze and interpret performance metrics in SQL queries?

Junior — Middle

OZON

What is the reason and necessity for overriding the Equals() method in your class?

Can you list the main types of data structures and storage formats in databases?

Given an array A of N positive numbers, are there three different indices i, j, k such that the sum A[i] + A[j] + A[k] ends with the digit M?

What are the differences between standard libraries in C and C++?

What methods can be used to remove key restrictions in a dictionary data structure?

What response code does the server return if no authentication token is provided in the request?

What does the Intersect() method do?

What distinguishes Action delegates from Func delegates in terms of their usage and purpose?