Java

[name] asked: If the topic has 100 partitions and the @KafkaListener annotation specifies concurrency=10, will 90 partitions be idle?

table student id PK name faculty_id table faculty id PK name SELECT f.name, count(*) FROM faculty f JOIN student s ON s.faculty_id = f.id GROUP BY f.id, f.name GROUP BY /*f.id,*/ f.name GROUP BY f.id/*, f.name*/

Middle+

Иннотех

Why is the finalize() method needed?

Senior

СБЕР

Can you explain what ExecutorService is and how it is used to manage threads?

Junior — Middle

СБЕРСБЕР Бизнес

What is a Saga and why is it needed?

Senior

СБЕР

What is the difference between map and flatMap in the Stream API?

What is important in a new workplace — project, tasks, stack, team?

Middle+

Яндекс Маркет

- list the names, with the first column showing the name, - the second column showing the number of visitors with that name, - the third column showing the number of visitors with that name and older than 27 years - sort by name in ascending order (A-Z) SQL code example: ```sql create table customers ( id int, name text, age int ); insert into customers values (1, 'John', 20), (2, 'John', 20), (3, 'John', null), (4, 'John', 37), (5, 'Jane', null), (6, 'Bob', 13), (7, 'Bob', 99); SELECT name, COUNT(*) AS total, COUNT(CASE WHEN age > 27 THEN 1 END) AS older_27 FROM customers GROUP BY name ORDER BY name ASC; ```

Tell about your current project at [company] — what are you doing?

Senior

СБЕР

What is effectively final in Java and where is it used?

Senior

Альфа-Банк

Question 4. What is JIT compilation? - Compiling code into a jar file - Compiling bytecode into machine code during program execution - Compiling JavaScript into machine code for performance optimization - Compiling a project in a git pipeline

What is the reason for the inadmissibility of inheritance from the built-in string type in a programming language?

Provide an example when it is not necessary to use microservice architecture, and name a couple of reasons.

Senior

Альфа-Банк

How are you generally with DevOps technologies — Kubernetes, CI/CD, and others?

How to display all departments including Accounting? What will be in max_salary for Accounting?

Senior

СБЕР

Why might a method with @Transactional not create a transaction?

Senior

IT One

package ru.tbank; @Service public class OrderService { @Autowired private OrderRepository orderRepository; @Autowired private CacheService cacheService; public Order findOrder(Long orderId) { Order order = cacheService.get(orderId); if (order == null) { order = orderRepository.findById(orderId).orElse(null); if (order != null) { cacheService.put(orderId, order); } } return order; } }

Middle+

Т-Банк

Can the argument of a method be considered a temporary variable inside a function?

10 application handlers take tasks from the database. How to prevent two instances from taking the same task?

Senior

Альфа-Банк

How else can the problem be solved without anyMatch?

Senior

Альфа-Банк