Java

Что такое дженерики и для чего они используются?

When you perform a regular SELECT, how many queries does the driver send to Postgres? What are these queries and what will be there?

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

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 important in a new workplace — project, tasks, stack, team?

Middle+

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

What indexes have you had to use (including covering indexes)?

Senior

СБЕР

- 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

How does the mediator pattern differ from proxy?

Senior

Альфа-Банк

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

Tell about a situation in the last year or two when you were most effective as a developer.

Senior

СБЕР

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

Senior

Альфа-Банк

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+

Т-Банк

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

Senior

Альфа-Банк