Can you explain what a HashSet data structure is and what it is used for?
Junior — Middle
221
C#
Where are you currently located?
Intern — Junior
219
What is the role of the stack in memory management and why is it used?
Junior — Middle
219
There are three methods that change product information (change state, modify tags, and set weight). Since there are plans to add another 10-20 methods that change product information (these methods can be implemented as NuGet packages in another service), it is necessary to implement a single method DoSomethingWithItem that, depending on the input parameters, could invoke any product modification. That is, the method could be told "Change state" or "Set weight" and so on, and its implementation would call one of the methods like StateChanger.Change or WeightSetter.Set, etc. The classes StateChanger, TagsSetter, and WeightSetter can be modified. The main goal is to preserve the business functionality. namespace ItemsService { public sealed class StateChanger { public enum State { Active, InActive } public void Change(int itemId, State newState) { } } public sealed class TagsSetter { public void Set(int itemId, string[] tags) { } } public sealed class WeightSetter { public void Set(int itemId, int weight) { } } public sealed class ItemsService { //public void DoSomethingWithItem } }
Middle
219
What is the role of the GetHashCode method when using a dictionary or hash collection?
Junior — Middle
218
How does asynchrony differ from parallelism?
Middle
218
What definition does SQL give for the process of collecting and analyzing data based on statistical methods?
Junior — Middle
217
What is the maximum amount of memory (heap) that can be used within a single application?
Junior — Middle
216
Can you explain the concept and mechanism of asynchronous functions using the async/await syntax?
215
What is the need for boxing in programming and how does it work?
Junior — Middle
215
What processes and consequences occur when an object is passed to a function or method in programming?
Junior — Middle
212
There is a task: atomically write an event to a broker (Kafka/RabbitMQ) and to a database. How to ensure transactional integrity?
Middle
210
Explain the principle of the Dispose method and its purpose in resource management.
Junior — Middle
209
How do the concepts of synchrony and parallelism differ in programming?
Junior — Middle
209
Can you explain what a task scheduler in an operating system is?
Junior — Middle
208
Требуется написать запрос, возвращающий артистов и самые ранние их альбомы в формате <Имя артиста> <Название первого альбома> <Дата выпуска первого альбома>. 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
206
What is the minimum acceptable income level for you in the current situation?
Junior — Middle
206
Can you explain what is meant by the term 'Dictionary' in programming?
Junior — Middle
206
Does automatic type conversion occur when comparing two structures in a programming language?
Junior — Middle
206
What is the maximum number of data stacks that can be in your application's structure?
Junior — Middle
206