Explain the working principle of Pessimistic Locking in Spring and its application when working with databases.
Java
Is an index created from multiple columns organized in a specific order?
What methods of interacting with a database through Spring Data do you know?
How to convert a Stream back to a List within the Stream API?
Has a database been used within server services and how was it implemented?
Have you reviewed the project presentation?
What mechanisms and tools do you use for working with databases?
What is the maximum number of non-clustered indexes that can be created in a database?
What type of index is most commonly used in databases?
What are the key characteristics of interfaces in programming?
Explain the concept of composite indexes in databases and their usage.
What reasons might lead you to avoid using clustered indexes in a database?
What type of index is used by default in the PostgreSQL database?
Have you had experience analyzing and tracking query execution paths?
How do you preserve relationships between parent and child classes containing fields in a database?
How did you measure the complexity and progress of tasks at your previous workplace?
How to implement error handling in applications using Spring Web MVC?
Have you used Criteria API for building database queries?
Have you used non-clustered indexes when optimizing a database?
Explain the principle of the @Transactional annotation and its role in managing database transactions.