Tech Active Solutions India Business Analyst Interview Questions and Answers

Q1. Tell me about your self
Add your answer

Basic maths question

Q1. SQL Questions - Constraints- how to optimize long SQL query without changing the output
Add your answer

Basic Js concepts like debouncing,event loop, and other output-based questions.

Q1. Js concepts in depth
Add your answer

Q1. Hiring manager round, questions around my project
Add your answer
Q2. Optimization techniques
Ans. 
Optimization techniques are methods used to improve the efficiency and performance of software applications.
• Use algorithms like greedy, dynamic programming, or divide and conquer to optimize code

• Minimize time complexity by avoiding nested loops and unnecessary iterations

• Utilize data structures like hash tables, arrays, and trees for efficient storage and retrieval

• Profile code to identify bottlenecks and optimize critic...read more
Answered by AI
Add your answer

Q1. Design a paginated list of items, then improve efficiency
Ans. 
Design a paginated list of items and improve efficiency
• Implement lazy loading to fetch data only when needed

• Use caching to store previously fetched data for faster retrieval

• Optimize database queries to reduce load times
Answered by AI
Add your answer

Q1. Basics on Javascript, ReactJS
Add your answer