C#

Tell about your experience with Rider, Docker, and development tools.

What is gRPC and how does it differ from regular HTTP?

How is the yield mechanism implemented internally?

What technology stack was used?

How does the check `is not null` differ from `!= null` in C#?

Middle

Альфа-Банк

Message delivery semantics between microservices.

Singleton with a lock object, static field instance, private constructor, and GetInstance method. What are the issues?

If you were to develop your own testing framework, how would you organize it without using reflection?

Middle+

Тензор

How soon can you start working after receiving an offer?

Why are you looking for a new job and what project format interests you?

Middle

Альфа-Банк

What energizes you at work, what do you enjoy?.

Explain the concept of thread-safe collections and their use in concurrent environments.

Tell how memory is allocated on the stack and in the heap. Are all value types always placed on the stack?

Do you know ref struct?

Why can't you write async code inside a lock?

What properties should a method or class have to be conveniently covered by unit tests?

How is the link between tables in a database implemented?

Tell me about parameter modifiers ref, in, out and their differences. What are readonly ref and ref readonly?

If you uncomment throw, will the output order change?

Дана таблица: create table bank_users ( id bigint generated by default as identity primary key, status int, employee_number varchar(8) unique, first_name varchar(100) not null, last_name varchar(100) not null, middle_name varchar(100) default null, email varchar(100) not null unique, created_at_date_time timestamptz ); create index ix_created_at_date_time_status on bank_users (created_at_date_time, status); Есть запрос: explain (costs off, verbose) select employee_number, first_name, last_name from bank_users where status = 2 order by created_at_date_time; Возвращает: Sort Output: employee_number, first_name, last_name, created_at_date_time Sort Key: bank_users.created_at_date_time -> Seq Scan on bank_users Output: employee_number, first_name, last_name, created_at_date_time Filter: (bank_users.status = 2) Что можно сказать об оптимальности плана запроса?