What steps would you take to diagnose the causes of low database performance?
Java
Can you explain what CAS means and how it is used in programming?
Could you explain what the term 'Explain' means in the context of this tool or model?
How can the performance of SQL queries in a database be improved?
What does the REPEATABLE READ isolation level mean in the context of transactions, and why is it important for data integrity?
How is the metric collection system integrated into the project?
Explain the meaning and purpose of the ThreadLocal class in multithreaded programming.
What is the role of a foreign key in a database and why is it important?
If Redis crashes, how did you handle this situation? Were the data from the last hour lost?
Why is it important to release resources after their use in a program?
What are the advantages and disadvantages of using CompletableFuture for handling asynchronous tasks in Java?
How is type erasure implemented in the context of generic types in programming languages?
Have you had the opportunity to work directly or access production servers in your last project?
What methods can be used to reduce cache growth?
Tell us about a large/interesting task you solved. What did you do at [company/project]?
Explain what an index that covers all fields for a query means in the context of databases.
What methods can be used to perform event logging in the system?
Разница между newCachedThreadPool и newFixedThreadPool. Когда использовать каждый?
Tell me about how the work process was organized: from whom you received tasks, in what form, what artifacts you left?
What are the differences between the implementations of the Map interface: HashMap and TreeMap, and in which cases is it preferable to use each of them?