C#

What is the difference between the HAVING and WHERE operators in SQL and when should they be used?

What is expected from a new developer in the first month of work?

Is the String type in Java or other programming languages a primitive or reference type?

What time frame do you expect to reach the level of technical leader in the team?

What is the difference between simply using throw and throw ex, and which method is preferable in different cases?

How does a window function differ from GROUP BY?

Can you give an example of applying a specific data structure in practice?

Are you familiar with SOAP?

What HTTP response code is indicated when a user does not have permission to access the requested resource?

Can you explain what a unique index in an SQL database is and in what cases it is used?

What is a feature toggle and how to implement quick disabling of a broken feature without redeploying?

Can you tell about your experience using gRPC in projects?.

Junior — Middle

Aston

What are your financial expectations according to the proposed position?

How did you store time series data: using a regular PostgreSQL or a specialized Time Series DB? Why?

Middle

Альфа-Банк

What are async/await and asynchronous methods used for?

Middle

Selecty

Can you tell about the key features of string data in programming?

What is dependency injection, where is it used, and what are the available lifetimes: Transient, Scoped, Singleton?

Can you explain what the isolation level in a transactional database means?

What language features in C# are used to implement the principle of polymorphism?

When are the arguments of a deferred function calculated? At the time of definition or at the time of call?