Explain the written SQL query: what do we retrieve, how do we retrieve it, why do we filter reaction not equal to 0, how do GROUP BY and ORDER BY work? Tell about JOIN types (LEFT, RIGHT, their differences).
Senior
118
Java
14621
265
producer 1 consumer 4 partition 3 topic 1
Senior
118
What are the message delivery strategies in Kafka and how are they implemented?
Senior
117
Tell us about yourself, your experience, what tasks you have solved, and why you decided to leave.
Senior
117
You started working in 2020 at 'Automated Transport Systems'; was this when you were 17 years old?
Senior
117
How to implement parallel calls in Java 17 without virtual threads?
Senior
116
Why is ExecutorService popular? What is its advantage over creating threads directly?
Senior
116
Write a method that returns the N-th element of the Fibonacci sequence.
Senior
116
SQL query optimization: what did it consist of?
Senior
116
How to run a task in a separate thread in Java?
Senior
115
How does a Docker container differ from a virtual machine?
Senior
115
How does valueOf differ from fromString?
Senior
115
Tell me about the equals/hashCode contract.
Senior
115
How does Spring Security work?
Senior
115
Which of the listed parameters of integration interactions does not improve with increased bandwidth?
Senior
113
Why and how did you switch to Kafka for asynchronous processing and load reduction?
Senior
113
What test cases would you write for this method?
Senior
113
How to implement the Strategy pattern for dynamically selecting a service based on entity type in Spring (coding task)?
Senior
112
The database is large, indexes are built, the plan has been reviewed — what else can be done for optimization?
Senior
112
What stages of software development and implementation were in your team?
Senior
112