C#

What is finally?

Explain what the ELK stack is and what it is used for.

Can you explain what is meant by improving the efficiency of SQL query execution?

How long can the process of changing jobs to a new position take?

Junior — Middle

OZON

Қиын жүйелердің архитектурасын жобалауда бұрын жұмыс істедіңіз бе?

What changes occur to an object when it is in the second stage of its lifecycle?

Do you have experience using custom exception classes in projects?

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

What are the advantages and disadvantages of using Reflection in programming?

How is your daily activity organized and how do you interact within the team at work?

Does ORM Entity Framework support executing queries via LINQ?

In what cases does automatic memory release occur by the garbage collector?

Can you give an example of implementing the dependency inversion principle in programming practice?

Junior — Middle

Andersen

Can you give an example of a situation where tables are related but do not use foreign keys?

Could you explain what the term 'nullable' means in programming?

Junior — Middle

IT One

Explain the differences between deployment and packaging of objects, as well as passing parameters by reference and by value in the context of working with reference types and structures.

What class or data type is returned when using the Where method in LINQ?

What database management systems have you used in your projects?

How is the Consumer interface in Java implemented and how does it function for message processing?

What actions does the API perform when receiving a request interruption signal?