Teamware Solutions Sr. Software Engineer interview questions

1-what approach you will use to optimize the query ad fast performance 2-what is cluster and Non cluster indexing 3-what is lazy and batch processing in springboot application 4-what is though and replication in kafka 5-how the register the microservices service and how to handle load balancing 6-what is the API flow. how to implement api 7-How to handle Exception in springboot application 8-java 11 and java 17 new features 9-what is Excutor servce and executor cache 10-what is is parallel stream and how do it different from normal streaming. 11-outh 2.0 authentication example 12-what all the design patterns with real time example 13-how to implement resilience and circuit breaker in microservices. 14-what is CQMS saga design pattern. 15-have you used versioning 16- Implement the api for this scenario : Emplyee_Master > emp_id, emp_name, manager_id Fetch Hierarchy of manager in upward direction based on employee id E1 > M1 > M2 >M3 > M4 > CEO (upward)