What approaches do you use to improve the efficiency of database query execution when working with large volumes of data?
Java
Have you used non-clustered indexes when optimizing a database?
Have you used caching mechanisms in your recent projects?
In which cases is it advisable to delete indexes from a database?
Have you had experience using API Criteria in JPA for building dynamic queries?
How do you preserve relationships between parent and child classes containing fields in a database?
Do you have experience in configuring and monitoring system metrics?
Explain the principle of the @Transactional annotation and its role in managing database transactions.
Have you used Criteria API for building database queries?
Have you applied inheritance in your previously implemented projects?
Can you tell how your projects improved user experience or solved user problems?
What was the reason for choosing a small database for the project?
What internal data structure does ResultSet in JDBC use to store data?
Do you have practical experience in developing or implementing systems that handle large volumes of data?
Can you give examples of scenarios where cluster indexes are used?
What components and multithreading mechanisms have you used in your projects?
Can you name the main tools and components used in the Spring Cloud ecosystem?
In what context and with what level of transaction isolation did you work in your last project?
In your subsequent project, was there a need to use composite indexes to optimize queries?
Share your experience using Spring Security in projects.