Java

Explain the principle of optimistic locking in concurrency control and its features.

Junior — Middle

СБЕРOne To Work

What method can be used to load the contents of a text file into a string variable in your programming language?

What happens when two keys receive the same hash code in HashMap?

What methods can be used to prevent deadlock in a multithreaded application when organizing code?

What tests would you create to check the behavior of the List interface?

What steps will you take to optimize a long-running SQL query?

Which metric is most relevant for evaluating improvements after optimizing a slow query?

What methods and tools can be used to diagnose the causes of stopping or slowing down a Java server?

How are the equals and hashCode methods related in Java, and why is it important to implement them correctly together?

Junior — Middle

Effective MobileIfellowАльфа-Банк+11

What are the main rules and features for handling NULL values when working with SQL queries?

What approaches are used to conduct testing to avoid future system performance degradation?

If two objects with the same identifier are created, will they occupy the same memory location and refer to the same instance?

What difficulties can be encountered when processing and using files in applications?

Can you explain the concept of pessimistic locking and what it entails?

Junior — Middle

One To WorkСБЕР

What tests need to be created to verify the correctness of adding an element to an ArrayList?

What can cause an index not to be used after its creation in a database?

What is your experience with Docker and how well do you know how to use it in projects?

What actions does the database system take when two transactions try to modify the same record simultaneously?

In what situations can resource deadlocks occur in multithreaded programming?

What actions occur if a version inconsistency is detected in optimistic locking?