How do JOIN operators work in SQL?
C#
How does the asynchronous method work in C#?
How is inheritance implemented in .NET?
What is multithreading, what tasks does it solve, and what synchronization primitives do you know? How does SemaphoreSlim differ from Semaphore and what is a Mutex?
Can you name the most common index types used in database management systems?
How does simultaneous access of multiple threads to shared variables in an application affect it?
How can a one-to-one relationship between two entities be implemented?
What tools or libraries have you used for implementing HTTP requests at your previous job?
Is it possible to initiate background operation execution inside a controller using Task.Run and continue processing the request?
Can you explain what MS SQL Server is and what its main functions are?
What is the difference between a static method and an instance method?
Is it possible to declare a class inside a function or another block and place it on the stack?
Could you explain what the HTTP POST method means and how it is used in web applications?
Can you explain how ManualResetEvent works and its purpose in programming?
Whom among well-known specialists in your field do you personally respect or consider a role model?
Can you explain what is meant by a one-to-one relationship in the context of databases or object-oriented programming?
What might motivate management to set extremely tight project deadlines?
Have you worked with distributed computing system architecture?
Are there special methods in C# that are called upon object destruction?
When working with ORM, which database development method do you prefer: creating code first or designing the database before coding?