C#

Explain why performing asynchronous operations inside a lock is unacceptable in a multithreaded environment

What is the main reason for applying the dependency inversion principle in software architecture?

How does dependency inversion facilitate easier testing of code?

What types of memory management issues can occur in applications and how can they be identified?

Can you list the main types of table joins in SQL and explain their usage?

Can you explain what a non-clustered index in SQL is and how it works?

Can you explain the concept of transaction isolation levels in SQL, especially what Repeatable Read is?

What is the maximum amount of memory allocated for the stack in the system?

Can instances of significant objects reside in the dynamic memory allocation area?

Can you explain how locking mechanics are implemented when using synchronized or lock in multithreaded programming?

How is a clustered index defined and used in SQL, and how does it differ from a non-clustered index?

Explain what transactions are in a database management system and their main properties.

Will the object change if its method is overridden in a subclass?

Is it possible to perform synchronous processing of a method declared with the async keyword?

What is the purpose of using the Repeatable Read transaction isolation level in database management systems?

What approaches exist to improve the efficiency of SQL query execution?

What are the main advantages and disadvantages of using a message broker system?

Junior — Middle

ПочтатехAston

What is the purpose of window functions in SQL and how do they differ from regular aggregate functions?

Could you explain what is meant by transactions in the context of SQL and how they ensure data integrity?

Can you explain what a semaphore is and how it is used to control access to resources?

Junior — Middle

ПочтатехTVisionOZON