Java

There is a table with 100 million records. You need to select all records where value > 100. What are the recommendations to minimize query execution time?

Senior

Т-Банк

Without Hibernate, how to implement optimistic locking manually using native SQL?

Senior

Т-Банк

Was there a code review in the team?

Middle+

Т-Банк

Are there any restrictions on indexes? What types of indexes exist (hash, B-tree) and when should they be used?

Senior

Т-Банк

JIT vs AOT compilation — what is the difference and advantages?

Senior

Т-Банк

Tarrifs are embedded in the code. How can you change or add tariffs without modifying the code and redeploying?

Senior

Т-Банк

Have you ever configured partitions or changed the number of partitions?

Middle+

Т-Банк

Tell me about the CAP theorem. What is it, and why is it needed?

Senior

Т-Банк

var list = List.of(5, 13, 34); list.stream() .map(x -> x % 10) .peek(System.out::println) .filter(x -> x > 3) .forEach(System.out::println); List<String> animals = List.of("dog", "cat", "parrot"); animals.stream() .sorted() .peek(item -> System.out.println(item)) .map(String::length); System.out.println(animals);

Senior

Т-Банк

Have you worked with PostgreSQL and query optimization?

Middle+

Т-Банк

HashMap vs TreeMap: differences, operation complexity, when to use?

Senior

Т-Банк

What guarantees does volatile provide? How does it differ from Atomic?

Senior

Т-Банк

How do hash indexes differ from B-tree indexes? Which is preferable for searching by last names?

Senior

Т-Банк

What is a feature lead, and what was your experience in this role?

Senior

Т-Банк

How to solve a report generation function that makes 4 independent REST requests in parallel and collects results?

Senior

Т-Банк

What technologies and stack have you most frequently worked with?

Middle+

Т-Банк

Have you had to write unit and integration tests, and how did you do it?

Middle+

Т-Банк

Have you confirmed that the issue is on the external integration side (they take a long time to process requests)? What actions can be taken for quick response and in the future?

Senior

Т-Банк

The marketplace system slowed down under load. Suspecting a database issue. What will you look for?

Senior

Т-Банк

What happens if cacheService crashes or Redis returns a timeout, and how to handle it?

Middle+

Т-Банк