C#

How to optimize a slow SQL query with a full table scan?

It is required to output a list of employees receiving the maximum salary in their department.

Tell us about yourself: what have you been doing, which teams have you worked in, and what have you done?

How does Scoped differ from Transient?

What are the main data structures in C# that you use?

Microservice architecture — how do services communicate with each other? RabbitMQ vs Kafka — what are the differences?

How many bits are in a byte?

What is a covering index (INCLUDE in indexes)?

Задача 2 Запрос выполниться? select field1 from TABLE1 group by field1, field2

A colleague's task has come to your Code Review What problems do you see in the code?

What is IEnumerable and IQueryable, and what is the difference?

What is the peculiarity of the string type (string)?

How is the request pipeline in ASP.NET Core structured from the front-end request to reaching the controller?

What does the Intersect() method do?

Is it possible to make DbContext (EF Core) a Singleton? What are the advantages and disadvantages?

What are deferred requests in LINQ?

What are the disadvantages of indexes?

Data formats — JSON vs XML, differences, where are they used?

What will be the order of output in the code: setTimeout(() => alert("timeout")); Promise.resolve().then(() => alert("promise")); alert("code");? What is this mechanism called?

How does binary search work? What does the function accept and what is its complexity?