C#

Is it worth using asynchronous approaches for resource-intensive tasks?

Explain what are data types that store references to objects in memory, and how they differ from value types.

Explain the concept of parallel computing and how it differs from sequential processes.

If a method run asynchronously executes synchronously, does the thread return to the thread pool after its completion?

How many different call stacks can be run simultaneously in one process?

Junior — Middle

OZONПочтатех

What types of errors can lead to memory leaks related to the stack in a program?

Is it worth applying asynchrony for summing elements of a large array containing a billion numbers?

Can you explain the mechanism of locks in multithreaded programs?

What types of table joins are you familiar with in SQL?

Какое назначение у оператора HAVING в SQL и в чем его отличие от WHERE?

Can a table in SQL be created without using a clustered index?

Can you share your experience working with different types of databases, their features, and applications?

Junior — Middle

OZONПочтатехTVision

Is it possible to perform locking operations inside a critical section?

How are the keywords ref or out used in C#, and what is their difference?

Can you explain what the transaction isolation level means in a database management system?

Can you explain what is meant by indexes in the context of SQL databases?

Junior — Middle

ПочтатехЭлисофтOZON+1

What should you do if the network connection disappears during a REST request?

What will happen to the array length at the end when performing a concurrent append from 1000 goroutines?