Mphasis Interview Question

explain the SOLID principles in Java? What are the different ways to do multithreading in Java, and which one do you prefer and why? How do you handle data synchronization issues between multiple threads? How to centralize exception management in Spring Boot and convert exceptions into error responses? What is the difference between AWS ECS and EKS? What is the difference between a load balancer and an API gateway? When can indexing actually slow down a query? Give an example. How will I analyze a complex SQL query with multiple joins to figure out performance issues? How did I find out that my database query was taking longer? Do I know how database views work, especially in MySQL and similar databases? Explain how I refactored the database queries for performance and indexing, how I identified the need, and the impact of those changes.