C#

If you change a string inside a method, why does the value of the original variable outside the method not change?

Can you explain the principle of the try-catch construct in programming and what it is used for?

Can you explain the concept of message brokers and their role in data exchange systems?

When can using an index lead to a decrease in SQL query performance?

What is a higher-order function? Provide an example of a JavaScript function that accepts or returns a function.

What difficulties and tasks have you encountered in managing the lifecycle of objects or resources?

Какова роль и назначение модуля Exchange в системе обмена сообщениями RabbitMQ?

What are the advantages and disadvantages of the Database First approach when working with databases?

Have you ever created an authorization system from scratch?

Can you explain what the 'catch' keyword means in programming and how it is used for exception handling?

How does an array differ from List<T>?

Does Go have inheritance or composition?

Collection of functions, loop 0-9, add lambdas capturing i, call all. What will it output?

What are the modes of garbage collector operation you know?

Junior — Middle

Aston

How was pagination implemented on the backend? Why does LIMIT/OFFSET perform poorly with a large number of records? How can this be optimized?

For what tasks is the 'using' construct in C# used, and what is it?

Types of transactions / levels of isolation?

Do you have experience in development or maintenance using the .NET platform?

What database management systems have you used in your projects?

Требуется написать запрос, возвращающий артистов и самые ранние их альбомы в формате <Имя артиста> <Название первого альбома> <Дата выпуска первого альбома>. create table Artists ( id serial primary key, name varchar(255) not null ); create table Albums ( id serial primary key, artistId int not null references Artists(id), name varchar(255) not null, release_date timestamp not null ); insert into Artists(name) values ('2Pac'), ('Wu-Tang Clan'), ('Eminem'); insert into Albums(name, artist_id, release_date) values ('The Slim Shady LP', 3, '[phone]'), ('Me Against The World', 1, '[phone]'), ('The Eminem Show', 3, '[phone]'), ('Enter The Wu-Tang Clan', 2, '[phone]'), ('Recovery', 3, '[phone]'), ('The W', 2, '[phone]'), ('2Pacalypse Now', 1, '[phone]'); select a.name, al.name, al.release_date from Artists as a join Albums as al on a.Id = al.artistId where al.release_date = ( select min(release_date) from Albums where artist_id = a.id ); with cte as ( select artist_id, min(release_date) as first_album_date from albums group by artist_id ) select a.Id, a.Name, fa.first_album_date from Artists a join cte as fa on a.Id = fa.artist_id;

Middle

OZON