Round 1 - BarRaiser (1.5 hours) Database 1. SQL vs NoSQL Schema difference. 2. What is Normalisation? 3. Role of Group By and Having Clause. 4. How does MongoDB handle large datasets? 5. Difference between LEFT JOIN and INNER JOIN. 6. A user table has the last login date as a column. Write a SQL query to find all the users who have been inactive for more than 90 days. Java Internals and Springboot 1. Role of API Gateway in microservices. 2. Purpose of Container orchestration. 3. Explain an orchestrator service. 4. Concept of generics in Java. 5. What is a circuit breaker in microservices? 6. How to configure to integrate JPA in Spring Boot? 7. What are inner classes? Explain their types. 8. What is an anonymous class? 9. Difference between shallow copy and deep copy. 10. Purpose of @SpringBootApplication annotation. 11. @AutoConfiguration annotation. 12. What do Lombok annotations offer? 13. What are starters in Spring Boot? Problem Solving/DSA (Java) 1. https://leetcode.com/problems/move-zeroes/ 2. Stack and Queue difference 3. https://www.geeksforgeeks.org/implement-stack-using-array/ Round 2 - Technical Discussion (1 hour) 1. https://leetcode.com/problems/container-with-most-water/ 2. Stream API - groupingBy 3. HashMap and LinkedHashMap 4. How to solve deadlock using threads in Java? 5. try/catch/finally block concepts 6. @Repository use in Spring Boot. 7. What happens if we replace @Repository with @Service in the DTO class? 8. Which is better between @Autowired and constructor injection? 9. To write some REST API endpoints. 10. How to insert and get data in Elasticsearch? 11. How to handle 1M users trying to hit an endpoint? 12. How does Redis work? 13. How to use pagination in Spring Boot? 14. How can we solve circular dependency in Spring Boot? 15. How can we see all logs of microservices in Spring Boot in a single place? 16. Explain @Transactional and @Profile annotation in Spring Boot. 17. SQL query involving GROUP BY and HAVING.
