C#

Каковы потенциальные негативные последствия чрезмерного создания индексов на все столбцы таблицы?

What will be the result of writing to a closed channel? Deadlock, panic, or an error returned by the write operation?

Explain the concept of asynchronous programming in JavaScript and its features

What are you currently studying or watching for development?

Why does the frontend communicate with the backend via REST instead of gRPC?

Can you explain what the Application layer in software architecture represents?

Can ACID be ensured with Redis?

Do you apply SOLID principles when designing a system?

Explain the concept of state machines and their application in programming.

How to structure an application by defining its main layers?

Explain what the abbreviation CQRS means and how it is used in system architecture.

Tell me about your work experience at your last job

Middle+

OZON

Is it possible to disable the tracking mechanism in the system?

You were given an application, and you encountered a deadlock in the database. How will you act?

Can you explain what is meant by the term 'entity' in the context of software development?

Have you ever used indexing in real projects?

Which educational institution or course are you currently attending?

Can you explain the mechanism of locks in multithreaded programs?

How does ValueTask differ from Task, when should it be used, and what are its limitations?

Middle

Альфа-Банк

What is the Unit of Work pattern and to what type of pattern does it belong?