C#

Explain the concept of asynchronous task execution and how it differs from the synchronous approach.

Can you explain what data indexing in a database is and how it affects performance?

How can resource-intensive tasks be organized to run without blocking the main execution thread?

Can you explain the concept and mechanism of asynchronous functions using the async/await syntax?

Junior — Middle

КонтурOZONФинГрад+2

Do you have experience using transactions in database management systems?

How do reference types differ from value types, and how does this affect working with them?

Junior — Middle

OZONПочтатех

What aspects of the stack operation can be improved to increase its efficiency?

Is it permissible to perform asynchronous tasks inside a lock in multithreaded programming?

Is it possible to place a reference type variable on the stack?

Does each thread have its own area for dynamic memory allocation?

Explain the principles and mechanisms of the automatic memory management system in your programming language environment.

Have you worked with writing SQL queries in your projects?

How do meaningful data types and reference data types differ in programming languages?

Junior — Middle

OZONПлатформаПочтатех

What is the difference between passing data to a method by reference and by value?

What is the difference between Dispose and Finalize methods in resource management in .NET?

Junior — Middle

ПочтатехIT OneТОП КЕЙС

When using the async method in a synchronous context, when does the thread return to the thread pool?

Can you explain what is meant by the term 'lock' in the context of multithreaded programming?

How are table joins implemented in SQL and how to use them?

How is the termination of objects most often implemented in Java?

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