C#

What does it mean that a data stream in Java is an unmanaged instance?

Can you explain what the DELETE operator does in SQL and in what cases it is used?

Can you explain the purpose of the Attach method in DbSet and how it is used?

Is element search in a dictionary always an operation with constant complexity O(1)?

Explain the working principle and main features of GraphQL as a client-server interaction technology.

Can you explain what is meant by the concept of DDD in software development?

Explain the concept of a hash table and how it is used for storing data

Junior — Middle

Pyrus

Tell us about the team and the role you performed at your last job.

Can you explain what a discriminator is in the context of Entity Framework and how it is used with tables containing hierarchical data?

Can you tell about your most significant professional achievement?

What type of transaction isolation is used by default in the database management system?

What is a query execution plan?

Middle

Pyrus

What is the characteristic of the search speed of elements in the Dictionary data structure?

Junior — Middle

ПИК Digital

How can you check the equality of two collections in terms of their elements?

What are the differences between the include and theninclude methods when working with relationships in ORM?

How is class inheritance implemented in the .NET platform?

How is user authentication and access rights checked in ASP.NET?

Can it be considered that dynamic memory in the heap is thread-safe when working in parallel with multiple threads?

How is request routing implemented in a controller?

Junior — Middle

Andersen

Explain the concept of a thread pool and its purpose in software systems.