C#

How can a variable be changed from multiple threads without synchronization primitives? What are atomic operations and how are they related to multithreading?

What is the N+1 problem?

How was it possible to reduce the response time from 0.5 ms to 0.2 ms?

What is MVCC in PostgreSQL and how does it affect the performance of SELECT after a large number of UPDATE/INSERT/DELETE operations?

Tell about your last workplace and your experience.

What is the algorithmic complexity of search in List and Dictionary? How is the Dictionary implemented internally?

Is it possible to bind a variable to a thread/task so that each task stores its own value? What are ThreadLocal and AsyncLocal?

What will happen if two threads simultaneously add values to a variable without synchronization primitives? What could be the results?

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

What is the complexity of inserting into a List and Dictionary? What are collisions in dictionaries?

How does a semaphore work? How is it different from a lock?

SELECT runs slowly — what could be the reason and what to do?

How to write text to a file simultaneously from two different tasks? How to synchronize access?

Candidate questions about the project (work format, team, processes)

How does asynchronous programming differ from multithreading?

How does Entity Framework differ from Dapper?