C#

Tell us about your professional journey over the past two and a half years: projects, products, tasks, and interesting nuances.

Middle

Ozon Fresh

Can stacks always be used to store value types?

Junior — Middle

OZON

Can you explain what the VACUUM command does in PostgreSQL and how it affects the database?

Junior — Middle

OZON

How does a class with static methods and fields differ from a regular class with non-static ones?

When is it recommended to use foreign key constraints in a database?

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

Have you dealt with in-memory caching systems?

How have you structured interaction with the database in your projects?

What is the main purpose of the .NET Standard interface?

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

Can you explain what TPL (Task Parallel Library) is in .NET?

Can you explain what the WebSocket protocol is and how it is used for real-time data exchange?

What salary range do you expect to receive in a new position?

How is a thread created and managed when using the Task class in programming?

What approach or methodology was used for organizing work on the project at your last workplace?

Can you explain what is meant by the concept of Predicate in programming?

Where in memory is the first element of an array located in an automatic memory management system?

Junior — Middle

IT One

What are the advantages and disadvantages of changing the second job?},{

How to understand which indexes are used and how the query is executed?

Are data considered important always placed in the dynamic memory allocation area?

Junior — Middle

OZON