C#

Asinxron kodda kirishni bloklash uchun lock operatoridan foydalanish mumkinmi?

HTTP/1 va HTTP/2 o'rtasidagi farq nima?

Ma'lumotlar bazasida ikki oqim (optimist va pessimistik) tomonidan bir vaqtning o'zida ma'lumotlarni o'zgartirishda konkurentsiya yondashuvlari haqida gapiring.

Ta'limda qaysi fanlar sizga qiyinchilik tug'dirdi?

Qaysi holatda ikkinchi async-metod alohida Taskda bajariladi?

Qaysi konkurent to'plamlari bilasiz va ular nima uchun kerak?

OSI modeli nima va nima uchun mavjud?

Dispose (IDisposable) naqshini haqida gapir.

Asosiy sinf o'zining aniq vorislari haqida biladigan yondashuvning nima yomon tomoni bor va uni qanday o'zgartirish mumkin?

Qancha vaqt oldin ishdan bo‘ldingiz?

San'atchilar va ularning eng erta albomlarini <San'atchi nomi> <Birinchi albom nomi> <Birinchi albom chiqarilgan sana> formatida qaytaradigan so'rov yozilishi kerak. 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

Qanday qilib qaysi indekslar ishlatilayotganini va so'rov qanday o'tayotganini tushunish mumkin?

Ikki turli serverda joylashgan 2 ta dasturiy ta'minotni integratsiya qilish kerak. Dastur A foydalanuvchini ro'yhatga oladi va Email orqali Ro'yhatdan o'tish Xabarini yuborishi kerak. Dastur B Email yuborishi mumkin. Tanlagan integratsiya usulingizning usullari, protokollari va mumkin bo'lgan muammolari haqida gapiring.

SOLID nima?

Middle+

OZON

Foydalanuvchining to'liq ismini saqlash (IDbRepository yoki ICacheRepository) va boyitilgan voqeani keyingi bosqichga uzatadigan metodni amalga oshiring (IEventSaver) Maksimal samaradorlikka erishish kerak Keshda 99.9% dolzarb ma'lumotlar mavjud Saqlash paytida voqealarning dastlabki tartibi buzilishi mumkin public async Task Enrich(IEnumerable<UserEvent> events) { }

Middle+

OZON

Go'da satr nima va u qanday tashkil etilgan?

Delegatlar nima?

Middle+

Pyrus

ref struct ni bilasizmi?

Stack nima uchun kerak? Nima uchun barcha ma'lumotlarni to'plamda saqlamaslik kerak?

Middle

OZON

ValueTask nima va uni qachon ishlatish kerak?