Synthesis Systems India Interview Questions and Answers

Sql mcq questions with medium difficulty

Q1. What is inheritance? What are advantages of oops? What's indexing in sql?
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
• Advantages of OOPs include reusability, modularity, and flexibility in code design.

• Indexing in SQL is a way to optimize database queries by creating indexes on columns to improve search performance.
Answered by AI
Add your answer

Q1. What was your previous job role? What methodologies did you follow while working?
Ans. 
I was a Software Developer at XYZ Company. I followed Agile and Scrum methodologies.
• Worked as a Software Developer at XYZ Company

• Followed Agile and Scrum methodologies for project management

• Participated in daily stand-up meetings, sprint planning, and retrospectives
Answered by AI
Add your answer

Q1. What are you leaving your current organization?
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges and opportunities for professional growth

• Interested in working on different technologies or projects

• Seeking a more collaborative or innovative work environment
Answered by AI
Add your answer

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

Basic maths question

General aptitude questions and technical questions

Q1. Array data structure based programming question
Add your answer
Q2. Object Oriented Programming concepts
Add your answer

Normal Aptitude and Basics of the Computer Core Questions

Q1. Tell about Yourself
Ans. 
I am a software developer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.
• 5 years of experience in software development

• Proficient in Java, Spring Boot, and Angular

• Strong problem-solving skills

• Experience working in Agile development environment

• Passionate about learning new technologies
Answered by AI
Add your answer
Q2. Write the code abt the right binary tree?
Add your answer

Q1. Normal Hr Questions
Add your answer

FInd 3 numbers in an array whose sum = k.

Q1. Past projects I have worked on
Add your answer
Q2. Design a Elevator system
Ans. 
Design an Elevator system for efficient vertical transportation
• Consider the number of floors in the building

• Implement a scheduling algorithm to optimize elevator movement

• Include safety features such as emergency stop button

• Allow for both manual and automatic operation

• Consider peak hours and traffic flow in the building
Answered by AI
View 1 more answer

Q1. Starting from full form of SQL to RDBMS, CTE and some most common window functions, they asked everything. Questions were easy.
Add your answer