C#

How to remove duplicates from an array? What methods are there?

Senior

СБЕР

Can you explain what is meant by a query execution plan in SQL and why it is needed?

Junior — Middle

OZON

What application programming interfaces (APIs) have you had to use in your practice?

Is programming included in the list of mandatory skills during training?

Have you dealt with microservices-based architecture?

Junior — Middle

OZON

Can you explain the differences between value and reference data types?

What is the purpose of attributes in programming or system modeling?

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

What strings are stored in the string pool in Java?

Can you show an example of using LINQ to perform queries on a collection?

Could you list the main types of classes in object-oriented programming?

How would you rate your C# language skills on a scale from 1 to 10?

Explain the concept of the third normal form in relational databases and why it is needed.

Do you work with message broker systems?

Have you had experience using SignalR technology for real-time implementation in your projects?

What ways implement the IEnumerable interface in the programming language?

What is the main functionality implemented by the IList interface in .NET and in what scenarios is its use justified?

Can you explain what the useEffect hook in React is used for and what tasks it solves?

What is the role of data packing and unpacking processes in programming?

Junior — Middle

СБЕР Тех

What are indexes used for in database management systems?