Java

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

СБЕР

When is an AOP proxy created in the lifecycle of a bean?

[Name] asked: Kubernetes has a memory limit of 1 GB, and JVM is launched with -Xmx 1 GB. How viable is such a setup?

What types of NoSQL databases exist and when should they be used?

Senior

СБЕР

class AlternatingPrinter { public static void main(String[] args) { AlternatingPrinter printer = new AlternatingPrinter(); Thread numberThread = new Thread(printer::printNumbers); Thread letterThread = new Thread(printer::printLetters); numberThread.start(); letterThread.start(); } public void printNumbers() { for (int i = 1; i <= 26; i++) { System.out.print(i + " "); } } public void printLetters() { for (char c = 'A'; c <= 'Z'; c++) { System.out.print(c + " "); } } } Предположим, у вас есть два потока. Один из них выводит (1,2,3...), а другой — (A,B,C...). Как обеспечить их выполнение в чередующейся последовательности (1,A,2,B...)?

Tell us about the MegaFon project, what did you do?

Why did you leave your last company and decide to enter the market?

What is ACID in databases? Tell about each property.

Senior

IT One

How to implement isPerfectSquare without Math.sqrt? Alternative approaches.

Name one technical improvement made on the project besides business tasks.

Senior

Альфа-Банк

How to increase the number of consumers in a group with ten partitions?

Senior

СБЕР

Как обеспечить exactly-once семантику в Kafka?

Senior

СБЕР

What is an aggregate function in SQL?

Why are B-trees often used for indexes and primary keys instead of hash tables?

Middle+

Альфа-Банк

[name] asked: what is idempotency?

Tell me how you implemented the Outbox Transaction pattern.

Tell about the levels of transaction isolation in databases.

What are the types of exceptions in Java? What is a Multi-catch Exception?

Middle

СБЕР

How to solve the consistency problem when using Kafka transactions between two services?

Senior

СБЕР

Why is tree balancing necessary? How is fast search achieved?