Java

What technologies have you used for authorization?

Senior

Альфа-Банк

How to build an efficient index for a column with low selectivity (for example, status: new/running/finish), when only the 'new' status is important?

In what sequence is this SQL query executed (query plan)?.

class ToInfinity { public static void main(String[] args) { //write code here for (int i = start; i <= start + 1; i++) { /* there should be an infinite loop here, nothing can be changed*/ } } }

What should be in the specification for it to be ready for work? What is your definition of ready?

Senior

СБЕР

Tell me about equals and hashCode: the contract, why hashCode is needed

What does the SELECT operator in SQL generally look like?

Senior

СБЕР

Tell us about yourself, your experience, what tasks you have solved, and why you decided to leave.

Senior

СБЕР

Who called whom in the synchronous chain? Tell about the business process — what calculation, who initiated?

What are the main interfaces in the Java Collection API?

How was code review conducted in your projects?

Senior

СБЕР

Code review: look at the getDivisions method (code screenshots) — what did you like, what didn't you like? Is the use of Insensitive Order sorting, error handling, streaming, etc., justified?

Tell us about your most remarkable achievement in your career.

Senior

Альфа-Банк

The client clicked 'Withdraw funds' twice. How to prevent double deduction at the microservice and Kafka level?

Scenario: There are 3 entities - user, chat, message - User has a name and registration date - Chat has a name and creation date - Message has text, author, and creation date - A user can be part of multiple chats simultaneously - A message must belong to a chat, and cannot belong to more than one chat at the same time - Describe the domain model in the form of tables

Senior

Ozon Финтех

Are there situations when a Kafka Producer waits for a Consumer?

Why did you use Spring Web for API Gateway instead of ready-made proxy solutions like Nginx, Envoy?

Tell us about the principles of SOLID

Middle

СБЕР

// 3 public class Variables { public static void main(String[] args) { A a = new A(); a.val = 1; inc(a); System.out.println(a.val); set(a); System.out.println(a.val); } public static class A { public int val; } public static void inc(A a) { a.val++; } public static void set(A a) { a = new A(); a.val = 10; } }

Senior

СБЕР

What is next after the first ticket? How to build further development for a junior?

Senior

ОТП Банк