Java

How can optimistic locking be ensured for managing concurrent data updates?

Middle — Middle+

ProoftechСБЕРТ-Банк+1

How are topics and partitions related in Kafka? Is message order guaranteed across different partitions?

Middle+

Т-Банк

How can you determine that a service restart is due to cache updates caused by OutOfMemoryError?

Middle — Middle+

Т-Банк

Given: CREATE TABLE profile ( id BIGSERIAL PRIMARY KEY, nickname VARCHAR, registered_at TIMESTAMP ); CREATE TABLE post ( id BIGSERIAL PRIMARY KEY, owner_id BIGINT REFERENCES profile (id), body TEXT, inserted_at TIMESTAMP, likes_count INT -- number of likes ); CREATE TABLE subscription_count ( profile_id BIGINT REFERENCES profile (id) UNIQUE, followers_count INT, -- number of followers following_count INT -- number of subscriptions ); Requirement: Select all posts published by users who have more than 500 followers.

Senior

Т-Банк

What are indexes? What is a transaction? What is ACID? What is a foreign key and why is it needed?

Senior

Т-Банк

Проводил ли ты когда-либо наблюдение за состоянием работы сервиса?

Junior — Middle

Т-Банк

How to add a new column with a default value to a table in production without locks and downtime? PostgreSQL specifics.

Senior

Т-Банк

SQL task: select profiles with more than 10 posts.

Senior

Т-Банк

How do B-trees and hash indexes differ in the context of data organization and their search?

Junior — Middle

Т-Банк

What are the main advantages and disadvantages of using ExecutorService in Java?

Junior — Middle

Т-Банк

In what cases and why is the ThreadLocal class used in Java for thread management?

Junior — Middle

Т-Банк

Explain what partial indexes in databases are and in which cases they are used.

Junior — Middle

Т-БанкAston

What methods can be used to eliminate the problem of regular server reboots caused by OutOfMemoryError?

Junior — Middle

Т-Банк

What type of data structure is an index in a database?

Junior — Middle

Т-Банк

High database utilization — what to suggest: partitioning, sharding?

Senior

Т-Банк

How are data structures implemented in Java and Kotlin?

Junior — Middle

Т-Банк

Have you received responses to this bank's vacancies in the last six months?

Middle+

Т-Банк

Have you worked with parallelism and multithreading in your projects?

Junior — Middle

СБЕРТ-Банк

If we have multiple instances of the application, how can we ensure that the same operation from the scheduler is not processed simultaneously by multiple instances?

Senior

Т-Банк

What system metrics should be monitored during regular service reboots to prevent OutOfMemoryError errors?

Middle — Middle+

Т-Банк