C#

What are the advantages and disadvantages of using denormalization in relational databases?

What is a Leaky Abstraction?

Middle+

Pyrus

What is meant by input-output constraints in the context of application performance?

What are Outbox and Inbox patterns?

What is the purpose of the ConfigureAwait method and how does it affect asynchronous code execution?

Compare monolith and microservices — the pros and cons of each approach.

How are you doing with Docker, and what is your experience using it?

Task: You are asked to review the code of a new feature that allows booking a tour (consisting of a flight ticket and a hotel). The feature for separate booking of a flight ticket and a tour already exists, and this task expects a unified method that books either the entire tour or none of its components.

Middle+

OZON

What is the difference between an array data structure and a list in terms of their usage and internal device?

How can you extend a class method without modifying the original code?

Middle+

Тензор

What types of relationships between tables in a database exist?

How does an abstract class differ from an interface?

String task: what will be output? How is the == operator overloaded for strings? What is a string interning pool?

IMemoryCache What are the pros and cons of using IMemoryCache in an application? What is OWASP top 10? Code metrics 1. What code quality metrics do you know? 2. Have you used them? 3. How did you calculate them? 4. Part of CI or adhoc Load What will you do if your service (web page) hangs on the test or load circuit, but locally everything works?

Is a task in async/await always executed on the same thread or can it be on different ones?

What will be printed to the console and why? (code with Task.WhenAll, Thread.Sleep(1000), and Task.Delay(1000))

Middle

Pyrus

What does the Except() method do?

How does the async/await construction work? In which thread is the code after await executed?

How have you optimized a heavy SQL query? What tools did you use?

Tell me about the Dispose pattern (IDisposable).