C#

Can you list the main types of indexes used in databases?

In what cases can the use of indexes in SQL become ineffective or lead to their failure?

What steps will you take in case of disagreements with a colleague or within the team?

Can asynchronous processes run simultaneously without a queue?

Junior — Middle

OZON

Explain what a mutex mechanism is and how it is used in multithreaded programming?

Have you had practical experience in setting up and working with relationships between tables in a database?

Does your resume meet the requirements for the next interview stage?

Why is it important to use Big O notation for algorithm evaluation?

How can different behaviors for projectiles be organized in a game engine?

What is the main function of the Record data type in programming?

Junior — Middle

Aston

What methods will you use to analyze and eliminate the causes of delays when reading data from the database?

Is it possible to perform synchronous processing of a method declared with the async keyword?

What are the advantages and disadvantages of using relational SQL databases?

Can you explain what a task scheduler in an operating system is?

Junior — Middle

OZON

Have you had practical experience using the Records data structure in your projects?

Junior — Middle

IT One

Can you name literature on C# that you have studied or used in your practice?

Where is the data structure usually stored?

Junior — Middle

Aston

How can you call an asynchronous function from a synchronous method?

Is it possible to declare an abstract method outside the definition of an abstract class?

Explain the concept of synchronization context and its role in multithreaded programming.