Sobes.tech

Can you tell about the essence of the project? What is it for the end user?

Middle+
164

In your opinion, why use containers when virtualization exists?

Senior
164

Write an SQL query that returns the number of orders for each user with a total price greater than or equal to 1000, sorted by the number of orders in descending order, in the following format: +---------+-------------+ | user_id | order_count | +---------+-------------+ | 111 | 2 | | 222 | 1 | | 333 | 1 | +---------+-------------+

Senior
164

What mechanisms are needed to not lose responses coming through webhooks from HeadHunter?

Senior
163

You mentioned transitioning from monolith to microservices — was this related to the search?

Middle
162

In Linux, the top command shows that a process consumes 146% CPU. Is such a situation real and should something be done about it?

Middle
162

What are transactions and what levels of transaction isolation exist, particularly in PostgreSQL?

Middle
160

What volumes of data were processed in ClickHouse?

Senior
159

Why are you considering a new place, and what is important when choosing an offer?

Senior
158

How actively are you looking for a new place and why did you decide to enter the market?

Senior
158

What is the essence of binary search and in what cases is it used?

Middle+
157

Do you have an idea about the difference between a thread and a process?

Senior
157

How can a process use multiple cores at the same time in Linux?

Middle
156

What are the financial expectations? Are you willing to consider an offer including bonuses?

Middle+
155

What relational databases have you worked with? Have you dealt with sharding and partitioning tasks?

Middle+
154

What is database normalization? When is denormalization needed?

Senior
154

What is a transaction, what levels of isolation do you know? What anomalies can occur? How does Serializable work in PostgreSQL?

Middle+
154

What other problems does TCP solve besides guaranteed delivery?

Middle
153

What transaction isolation levels are available in SQL (PostgreSQL)?

Middle+
153

What do you want and what don't you want in your new job?

Middle+
153
/13