C#

How can tables in databases be related to each other?

Junior — Middle

Andersenappfox

Explain the differences between lock, Semaphore, and Mutex locking mechanisms.

What is the relationship between asynchrony and multithreading?

What is the JOIN operator in SQL and how is it used to combine data from different tables?

How to implement a 'one-to-many' relationship in a database or in C# code?

How does ORM affect the optimization of executed SQL queries and what does it generate as output?

Describe the stages and features of the software development process at your last place of employment.

How do the yield and async/await mechanisms differ when working with asynchronous programming?

What tools or methods do you use for deploying applications or services?

How is the List data structure implemented in memory and what mechanisms underlie its operation?

How do you analyze and review query execution plans in MS SQL Server?

What are the advantages and disadvantages of using the result via 'result' for data processing?

In what cases and with which objects is the 'using' directive used in C++?

If we use the ref and out keywords in C#, does the structure become a reference type?

Can you list and explain the main collections intended for use in a multithreaded environment?

How do reference data types behave in C#?

What are the data types available in .NET?

Can you explain what common table expressions (CTE) are in SQL and what they are used for?

How is the Equals method implemented when working with dictionaries and how does it affect data handling?

Junior — Middle

OZON

How is data storage organized in Redis?