Sobes.tech

What case in your practice left the most vivid impression due to the difficulties or mistakes encountered?

Junior — Middle
341

How to determine the language of a user visiting the site for the first time?

Middle
339

How do you compare and choose the most suitable option from several conditions or job offers presented to you?

Junior — Middle
297

Which organization do you plan to join in the future?

Intern — Junior
287

Can you explain the principle of dependency inversion and how to apply it in software development?

Junior — Middle
259

What is the worst-case time complexity of quicksort?

Junior — Middle
250

What areas of professional skills are you interested in for further growth?

Junior — Middle
223

What was your last salary at your previous job?

Junior — Middle
215

What can reduce your interest or motivation when performing work tasks?

Junior — Middle
214

Have you ever received job offers that you decided to decline?

Junior — Middle
211

Task 3 Given the following SQL database structure --Table Departments create table D ( Id int primary key, Name nvarchar(100), ) --Table Employees create table E ( Id int primary key, DepartmentId int foreign key references Departments(Id), Name nvarchar(100), Salary float, ) Required: a. Write a query to get the name of one employee with the highest salary in the company and the name of their department b. Get a list of departments where the average salary is more than $1000

Middle+
203

What problem or task would you like to implement or improve during your work?

Junior — Middle
200

What is the usual period for adaptation and mastering new conditions when changing jobs?

Junior — Middle
191

How does ConcurrentDictionary work?

Middle+
176

There is a customer support process. Within it, there is a process of assigning support tickets to an operator. An operator can have no more than 5 tickets at the same time.

Middle+
170

SQL task: a) Get the name of the employee with the highest salary and the name of their department; b) Get a list of departments where the average salary is more than $1000.

Middle+
167

Which of your completed projects or tasks was the most memorable or interesting for you?

Junior — Middle
167
/4