PolicyBazaar Technical Associate Interview Questions and Answers

Online test with Aptitude MCQs and 2 medium level coding ques

Q1. Explain SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN retur...read more
Answered by AI
Add your answer
Q2. Talk about your project
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines
• Implemented user authentication and authorization features

• Utilized Agile methodology for project development

• Integrated with Google Calendar API for task scheduling
Answered by AI
Add your answer

Q1. System design of elevator
Ans. 
System design of elevator involves planning the layout, selecting appropriate components, and implementing safety features.
• Consider the number of floors the elevator will serve

• Choose the type of elevator system (e.g. hydraulic, traction)

• Design the control system for efficient operation

• Incorporate safety features such as emergency stop buttons and sensors

• Plan for maintenance and servicing schedules
Answered by AI
Add your answer
Q2. Client server architecture
Add your answer

Q1. Simple coding questions and questions related to your work
Add your answer

Q1. Some logical questions and simple coding questions like arrays, loops, anagrams, palindrome
Add your answer

Q1. Oops : ploymorphism and abstarction
Add your answer

Q1. Puzzles : the water puzzle
Add your answer

Q1. Singleton design patterm, login
Add your answer

Q1. Normal behavior questions
Add your answer

Basic DSA questions to check the approach

Q1. Array sort and split
Add your answer
Q2. Sql query with joins
Ans. 
SQL query with joins
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. Angular directives, pipes, services, state etc
Add your answer
Q2. C# controllers, services, projects, entity framework, exception handling
Add your answer