МТС

Which team is used to insert a value into a table?

What text will appear in the console when running program №75

Definition of the sequence of execution of main SQL operators

What happens inside NSOperation when the cancel method is called and how is its logic implemented at a low level?

Have you worked with WebSocket protocol for implementing bidirectional communication in applications?

Could you explain the principle of data caching system operation?

What output will be obtained in example №6

Explain the working principle of the garbage collector (using G1 GC as an example)

What ways can you stop or cancel a thread of execution in an application?

What is the main role and advantages of using Spring Boot in Java application development?

If there is an endpoint with a controller, service layer, repository, and external integration — what tests would you write?

Employees with a missing manager in the database

Can you explain the mechanism of deadlock and situations in which it occurs?

Do you have any questions about our company that you would like to discuss?

Refactoring completion of a simple class

Optimization of the cell search function in an array

Can you explain the concept of resident memory in the Linux operating system and its role?

Which operator is used to obtain only unique elements from a dataset?

Analysis and fixing bottlenecks in database queries

Aggregation of daily sums and number of payments

Determining the best indexes to improve SQL query performance

Review and debugging of React components

Expected console output – task 109

Counter generator with closure