Can you explain the principle of the Mediator pattern and its main purpose?
Junior — Middle
226
C#
How can you manually trigger garbage collection in C#?
Junior — Middle
225
What is ConfigureAwait(false)? What is it used for? What is a synchronization context?
Middle+
225
How does using await help avoid blocking the main execution thread?
Junior — Middle
225
Have you dealt with complex SQL query optimization tasks? Have you encountered EXPLAIN ANALYZE?
Middle
225
How are tests conducted, and what is your experience with unit testing?
Middle
225
Have you worked with JWT? What does JWT consist of and how are its parts separated? Where is the payload located?
Senior
225
Explain the purpose and use of the HAVING operator in SQL queries.
Junior — Middle
225
How to optimize the Enrich method for 10 million events with different IDs? How to limit parallelism?
Middle+
225
Name two principles of SOLID, give examples of their violations.
Middle
225
How is it determined where to allocate memory for a variable (stack or heap)?
Senior
225
Are there bonuses and how is promotion arranged?
Middle
225
What is the Dependency Inversion Principle (DIP)?
Middle+
225
What is dependency inversion principle (SOLID principle)?
Middle
225
What is your grade in your current company?
Middle
225
How long ago did you resign?
Senior
224
In a Kafka consumer group, if one consumer constantly connects and disconnects, does it affect reading by other consumers in the same group?
Senior
224
What types of index structures are available in PostgreSQL and for which cases are they applicable?
Junior — Middle
224
What does a CPU usage limit during program execution mean?
Junior — Middle
224
Why is there no read uncommitted in PostgreSQL?
Middle+
224